A few years back, my wife would have said a similar thing to the OP. She would have complained about me sulking or having a bad attitude - she'd have probably said every few weeks.
She'd say I nagged her all the time; that she was poorly/tired/at work in the morning/on her period; that everyone had dry patches.
She'd say she wouldn't have sex with me when I'm "like that".
And seeing how this thread went, I'd be called everything from emotional abuser to rapist. Charming.
But the truth is, it was every couple of months. Not weeks. I wouldn't ask all the time, maybe twice a week - if the kids had behaved and there'd been no stress, if I thought she might be in the mood.
If I was lucky, I'd get an perfectly valid reason why we couldn't. No problem. But she'd say she was tired, then stay up until 11 watching some reality based shite, probably with Ant and Dec in it. The thing is, after a couple of weeks that started to burn into me - I'd try to ignore it, but eventually you realise that you're not as exciting as X-Factor....and that fucking hurts.
She got the implant and her periods went nuts. Again, it's a perfectly valid reason and that's not my thing anyway. At one point, she had a period for 6 months. Didn't go to the doctor. Didn't even mention it when she got a new implant. And you know what, it happens again. Now she'd rather bleed than have sex with me.
If I was unlucky she'd sneer and laugh a "no" - like I'd just suggested painting the living room black. And the worst thing is, she wouldn't even look at me. I genuinely can't even explain how hurtful that is - how it just sits there and gnaws away at you.
The sulking part would true. Ish. I wouldn't be sulking. I just couldn't even bear to be in the same room as her. Why the hell would I?
Finally, I really tried to talk about it with her - as soon as I mentioned it, she said "Just have a wank". That was it. Conversation over.
But sex isn't just a mechanical thing. The reason you cope on your own is because you're on your own. There is no-one else. Sex is about a couple - about feeling loved, wanted, attractive and desirable - about having a moment that's just for you two.
I stopped asking for sex that day. It was about 2 years ago. We've had sex less than 10 times in that time, and once in the last 5 months.
So, you know what - I have bad days. I have days where I feel repulsive or loathed; so I take myself off and sit and do something in a totally different room. Because it burns away at me all the time and sometimes I just don't even want to think it anymore.
You've assumed a lot about the OP's husband. Just consider he might well feel hated in his own home.