Well gee, you are only human and often after having kids, this can happen.
You are not the only one.
Perhaps, just bond with your Husband, without feeling "pressure" to perform. Meaning, just talk with him, confide in him, let him know that it is not "him" but that, it is common that with many Moms, they can get this way.
Make sure you tell him, that you are not the only one, with these "issues."
Just nicely talk with him... explain that you need more help around the house, compliments or just him noticing you for everyday things, too.
Not just noticing you when he is in the mood.
And Moms, can get too touched out. Meaning, they are with the kids ALL the time and doing things for everyone else... and by the end of the day, they are worn out and just need to be, not pressured about things, daily.
Their cup, gets empty.
Encourage your Husband, to refill that cup. He can do things for you too. For a woman/Mom, that means helping and doing things with the kids too. So that you can re-group.
Re-grouping and having respite, for a Mom, is very important. Otherwise, we are like a Hamster on a ferris wheel. Constantly, constantly, going and going and non-stop. Then at night, maybe, we can relax.
Maybe just do "relaxing' things with your Husband... and it may lead to other things.
And even if you are not in the mood for the full thing, maybe you can just satisfy him on other ways.
At least, he still wants you, in that manner.
And that is good.
But yes, you need to communicate with him... so that he does not feel you are rejecting him or not thinking of him. Explain... that the entire day every day, and with kids, leaves a Mom, just spent. Then we never have time to just be... or to re-group. And that is important, for a Mom/Woman/Wife... otherwise, we shut down. Even if we don't mean to.
Bond with Hubby in other ways too. Think of things, relaxing things, you can do together. Like playing board games, watching a favorite show together or a movie. Just hang out... and have a conversation about whatever. When is the last time, you both just did that or had a conversation about whatever? That could help you feel more bonded with him... and he with you, too. And that is also being affectionate and sharing, and being "connected" with your spouse. Which for many women, this is important in feeling, in the mood.