First, sex is not just sex. When you were not in the mood, he probably felt rejected. Now that he has given up on the R, you want sex. Confusing to most guys. Position "A" was a no go when he wanted a R with you, now that he doesn't want a R with you and is thinking about leaving, you say OK. So in his mind you were just holding out on him. (just my guess)
Sure he wants some form of sex but he also wants acceptance, which probably he didn't feel when you were not into sex.
I have some similar issues with my W, BB. When I with draw from the R, she becomes interested. The closer I feel towards her she withdraws or wants things more her way.
I don’t always know what to do but say that is the way it is. Maybe there is something you, my W, and other women have in common. Maybe it is common with both sexes.
So my best insight or advice is he wants to be appreciated, feel connected, and valued so look past the physical sex acts. Maybe what sex he has with you is because of just basic urges.
I bet he wants more of what he didn’t get when your kids were babies. Aske him what he wanted then that was more than putting tab “A” in slot “B” and getting off.
What order are your priority? a)Kids, work, self, spouse, things, parents and siblings, or b)Your sanity, spouse, kids, work, parents and siblings, hobbies.
B is better than a. Yes a spouse comes before kids sometimes, that way they can do more for the kids. Your screen name indicates the kids have a bit too high position in your M. Am I right or wrong?