Hi OP - I think you deserve perspective - not just like minded women to share the same feelings. So FWIW - I think this is one of the greatest causes of misery and marriage break up, not because of where it starts but where it ends up. It's like not brushing your teeth - it will not lead to losing all your teeth today, or tomorrow - you'll just have bad breath. But allowed to just go on and on will end in pain and extractions - and if you don't really care, you won't notice soon enough.
Often the pattern is that children and general drudgery make life harder than the early days, and often women can store small resentments, blame DHs for the condition of their lives, for the small let downs and disappointments and withdraw, feel too unhappy, dissatisfied or disappointed with DH to feel amerous toward them. (Of course DHs can start to crave variety and feel bored too, but less likely to refuse sex or go off sex entirely). The small problem, like the sticky tooth, then festers. There is nothing worse for DH's self esteem than feeling the lack of desire for them from DW, which is the start to feeling unappreciated. They will eventually become more angry, depressed, withdrawn, snappy, huffy, moody - all of which are very unattractive qualities that will make things worse.
Women often have their sexuality awoken again after a long dormant phase by an experience with someone other than their DH - and then the strength of what's left of their diminished marriage relationship will determine what happens next.
So - no you should never be expected to have sex, ever. Of course no means no!!
But equally you can't expect a happy loving relationship to last without it unless your DH is equally happy with a sexless marriage. And while the decline of intimacy in your relationship may not seem a big deal today or tomorrow - be careful that it isn't too late by the time you notice just how important it has been, and the difference it makes looking back. Perhaps try to discover why you are unable to feel sexually interested in DH, and what you expect to happen, talk to him about it and how it feels for each of you right now. To say you resent the time you could have been sleeping after sex should be an absolute red flag that things are starting to go badly wrong. Personally, I think your DH should move out for a while, give you the chance to stop resenting him, give him the chance to find himself, and for you to start seeing him as a man with agency and choices not just the father you are stuck with and who is stuck with you. What do you think?