One of the biggest problems seems to be you had just gone to a big event prior to this. When hubby makes plans, I try to save up energy. If a new place opens up, we wait a little while since we know it will be crowded until the novelty has worn off. He has learned I'm not always up to being spontaneous, even though I love to be that way sometimes.
Our most popular nights to go out to dinner are Mondays and Tuesdays. Not as crowded, usually. Sensory overload avoidance in a way.
We have date nights at least once a month. Perhaps this may help? I make sure I don't do too much on those days so I can have fun with him.

I'm sorry that your DH got upset. Perhaps it's his frustration and worry? We really can't help it when things go wonky. I feel guilty a lot when I know I shouldn't. I do what I can, but even then sometimes things happen.
Perhaps having a heart to heart when you've both calmed down. My DH and I have these on occassion.
Sorry so long. Hang in there.