Did I ruin the mood?

I was about to have sex with my partner and I mentioned I was debating between 2 positions because I was feeling tired. He basically said I ruined the mood and we didn’t have sex. We’ve been together almost 3 years.. I guess to me it’s normal to be tired and still want to have sex and didn’t see a problem being open about it considering we’ve been together for a while. Did I kill the mood?