It last forever, no, but neither will your husband's patience. You can't just unilaterally hit the pause button on a sexual relationship for years and expect everything to just hold together. 80% of your sex drive is down to him looking after you emotional and sexual garden yes, but there's 20% you can take responsibility for like telling him the most direct ways he can help you switch off mom mode and relax enough to think about intimacy. He may not always be able to Intuit that.

I enjoy sex once it's happening but I don't think about it otherwise. I don't masturbate even

I know women who are like this and reading erotica makes a huge difference to it. It has the same effect as enjoying sex once it's happening but without all the stress and aggravation of getting to that point. Plus you can just stop reading of you're really not in the mood.

Everyone in this thread who's basically re written Come As You Are in their comments is correct, but you, OP's wife and all wives with a responsive libido in this position have to be a team player in making the situation bearable.