The knickers-in-a-twist cries of sexism are not true as in reality a woman who doesn't work IS judged far less harshly than a man who doesn't.
That's just a fact.
His sex drive may be low as his self-esteem is low as he is not working.
I don't think women's sex drives fall much if no paid employment.
Anyway, the guy sounds depressed and burnt out and in need of help. He wasn't always like this and this differentiates him from a bog standard cocklodger.
Also, I'm a bit critical of the OP - does she have such a high paying job, as her dh did, I wonder?
Maybe if she did, she'd be a burnt out wreck and all.
Still it is what it is and given his state it's hard for her to respect him and when a woman don't respect a man she doesn't want to have sex with him, either.
This obviously does NOT apply to men about women.
Also, even if the sahp is a man who agreed beforehand to be such AND does ALL the domestic stuff, the wife still goes off him and he still feels impotent in life.
So my advice to OP is a last ditch attempt to help him then if he won't co-operate end it. He deserves that as not always a lazy bum.
It's near impossible for a woman to respect a man who doesn't work. Not the same the other way around.
Accuse me of sexism, I don't care. It is what it is.