I would have called him on it.
In a "neutral" mature manner. Not in a way to "criticize" him... but in a way that would be telling him you notice, you are wondering why, and that it is affecting EVERYONE in the house, and what is bugging him.
And if he can't snap himself out of that mood, then he could go to another room, by himself and deflate.
Not saying anything, just makes things worse. And then everyone walks on pins and needles. NOT fun.
But he needed to know, that he was affecting everyone in the house.
And being he is an adult, he COULD have said "sorry I'm in a bad mood, I just need a quiet moment to myself..." and then go to another room and deflate.
When a person is grumpy, they can either make everyone else grumpy and spoil it for everyone, or they can recognize it, say it nicely, and then DO something about it, to improve. ie: go to another room and be grumpy by themselves. OR he could have just SAID what is bothering him, why... and then express it to you, in an adult manner.
NO ONE, can read his mind.
So it is rude of him, to act like a fussy Toddler.
And it was also his birthday, if he did not say, how he wanted to celebrate it nor his expectations for it, then that is his, fault.
He could have said, what would have made him happy and how he wanted to celebrate it.
Call him on it.