Embarrassment

If she is a friend she knows you so don’t be embarrassed. As long as you didn’t offend anyone don’t worry falling asleep isn’t offensive.
After what we have all been through the last eighteen months there’s going to be lots parties and drinking.
We went to our rugby club today not been there since 2019 (we didn’t get drunk ) But we all had a toast to be grateful that we are survivors?

No one has been as friendly with me as they were

I think says it all.

Getting so drunk your friends are embarrassed for you? Not a good look at any age. Sounds like an apology and flowers might be in order. And maybe a very low profile for a bit.

The fact is we can’t drink as much as we used to, in my case I don’t have any alcohol in the house so when I am offered some at friends, I have to be very careful as it goes to my head straight away.
You could throw a dinner, or a lunch party with your friends just to make it known you are capable of doing these things, without mentioning the unfortunate incident. If someone brings up the subject, just laugh it off by saying it wasn’t your day.