That is such a realistic dream. I've had situations like that before. I think all of what you are feeling is so normal. At least I think it's normal because I felt that way, too! So, it must be common right? ;)
Social situations are hard to navigate sober. It does get easier but I don't love going to bars or events where people are getting plastered, still 2+ years in. Just this weekend I went to a 2.5 hour dinner (which is WAY too long for me) and was somehow convinced to go to this club after. Hated it but I did it.
We can always do these things and leave early, if you still want to go to bars, etc. where your friends are hanging out. That, for me, always makes it easier... knowing I can leave at anytime.
Plus, going out for a run/walk while all your friends are hungover is the better option! I'll never regret a night not drinking but would for sure regret if I went back to it. Hang in there! All we have is today!