I have had similar to this with my DH, who is pretty much teetotal.
A friend had a landmark birthday a couple of years ago and invite us all away for a weekend. Lots of champagne, lots of fun and staying up late. It was our first weekend away with out the DC ever. DH gets on with these people well and has lots in common with the men (similar jobs and hobbies).
Dh was a bit of a party pooper at the weekend, moaning he couldn't sleep because of the party, having indigestion and so on. It was like a weekend with Victor Meldrew. I had a fantastic time, but when we got home I had to face the music from him, moaning and sulking. I felt really dragged down and fed up with him, and I felt like it for a couple of months, really down and like I couldn't be myself anymore. Like you say OP, I didn't get out much at all and the one chance I had he ruined it. He made me feel horribly guilty but even so I basically laid it on the line to him that if he was going to behave like that I'd go on my own in future. There was a standoff.
Anyway I'd made a few new friends as my DD started school and started going out with them a few times, having a great time, nothing dodgy, just a few drinks and fun and I think it opened DHs eyes, he had some sort of realisation and actually apologised, said he wouldn't be so grumpy in future.
We went away again this year, with the same friends and both had a fantastic time.
So maybe you do need to get out more? Give your DH a bit of a taste of his own medicine?