You husband acted fairly 'normally' by wanting to have sex / be intimate with you while you had the house to yourself.
You of course have every right to say no, and without him being sulky about it.
That said, there's a big difference between 'he thre a strop and now isn't talking to me - he always does this' and 'he's a little quiet because he feels I'm always rejecting him and he worries I don't fancy him anymore'.
If he is otherwise a decent, kind man, who doesn't try to control you with his moods, and doesn't think you owe him sex on demand, then perhaps it's more the latter.
Don't pretend to enjoy sex, or have sex you don't want. That will do you and your relationship more damage. If he's a decent person, he'd be appalled to know you'd lied, and to know he'd basically had sex against your will.
But you do need to have an honest conversation about your sex life, I believe. Allow each other time to talk about how you feel about it / what you'd like to change, and then you can both decide if you're happy with that way of living.