Please ignore pretty.
Her advice is nothing but a hand maidens to serve men.
I would imagine had I posted whilst in your position (Which I have been) I would be feeling a hell of a lot worse from having read it.
What she seems to have missed in her diagnosis, is not that you have gone off sex per second, but that you have gone off sex with him. So no amount of letting him have all the sex he wants (grim) is going to fix the situation.
Well, it might fix it for him, as that his is only gripe it would seem. You however, will feel a lot worse. You will in fact resent him even more. And any issues that you have now, will still be there, along with the added resentment.
Instead of trying ever now and then to have sex with him, or trying to tell him your issues, tell him there will be no more sex at all. Tell him, you can't have sex with someone when they disrespect you by thinking you are their personal servant, and ignore the fact that you are struggling with life and all they care about his their own sexual needs. Tell him, until he starts being supportive, you will be unable to have any sex with him, as you don't find him attractive because of it and you have lost respect to for him over it.
Say, if he's really bothered about sex that much, it is up to him to move towards making it happen, because pestering you constantly is killing your love for him, nevermind your libido.
You don't have to be the solution to this. That's our female socialisation talking (pretty take a bow)
It is just as reasonable to expect him to find the solution. He's not some special God, I'm presuming. He doesn't need your bending over backwards to meet his needs, for you both to be happy.
That way of thinking is straight out of 50 ways to please your man. Trust me, if you have to do that, he isn't a man worth holding onto.
Stand firm.