Is it wrong that I don't want to cuddle with my husband at bedtime?
Does he do something annoying when you cuddle?
No, it's just too embarrassing when we do that under the covers in front of my drunk friends.
That's understandable. It's fine to want to keep your space like that, especially when friends are around.
I was always a good wife, I don't know why he has a problem up with me
It seems you and your husband are not on the same page about what you both want when it comes to sleeping next and having friends around. It's best that you discuss your problems with your husband so that he knows where you stand.