I personally am concerned that you need to be drunk to have fun or feel happy. I am happy and have fun being sober. Do you consider your drinking habits a problem?

If you need to be drunk for true emotions to come out, then you are in the beginning stages of drinking problem and perhaps addiction.

Yes in general seeing ones partner drunk and stumbling is very embarrassing (let alone vomiting on themselves!!!!). Especially in front of families! It's understandable he was embarrassed.

You maybe thought that you appeared happy and cute having fun. But to outsiders (especially sober ones) drunk people don't appear cute at all. They in fact look and behave in a very embarrassing manner. So consider that your boyfriend wasn't embarrassed of you "happy" but of you "drunk"