Is he not allowed to be frustrated, upset, fed up of being rejected? I wouldn't class any of those things as sulking.
Anyway, you're not unreasonable to not want it at a specific time, whether that's 6am or 10pm, however, I think in a relationship it's not good to never want it/be in the mood/have the energy. It can be a challenge when you got lots of kids & pets to have any energy left or not to feel 'touched out', but your partner deserves your time & energy too. I think you need to make the time & find the energy for sex in a relationship. Often too, the more you have, the more you want, otherwise it's easy for 'No' to be the default.
What was his approach like? I love being woken up by being kissed, touched etc and as long as it's a low effort affair I'm all for it. No hanging from the chandeliers before coffee though, that's for sure! However, if I was woken up 'normally' and asked if we could have sex I'd probably smother him!
Do you actually enjoy it once you get started? The blokes in my relationships, have been very compatible with me, good, easy, comfortable sex when one of us has been tired and not up for a shag-a-thon, all except one, for whom it was an Olympic bloody event everytime...great for when you've got the time & energy, but not for a morning quickie when you're still half asleep. So, although the sex with him was mind blowing, we had far less sex than with others.