Tension is, imo, ephemeral. If you keep chasing it, you are chasing dopamine loops. Little good comes from this.
But meaning is different. When you can remind yourself a truly great "why" you are doing something, can re-frame it, it can help.
Most importantly, boredom, irritation, and anxiety are temporary. They are emotions. They do not define us or the work. It was a joy when I realized that all these emotions will pass. They really do. You can sit with it. You really can. You can't make it go away, but it will pass.