At least in the pub you get camaraderie, affection, and fun.
I think you're looking at it with rosy glasses, enfin - at least remember the bad stuff too, yeah?
I never go to pubs now, and I can promise you ,y social life has never been better or more fun....but it took time to build up to that.
It's going to take you a little time to get over what happened to you last time you where in the pub , and it going to take you a little time to re-appraise your idea of fun and where to find it.
Think about hobbies and interests and things you'd like to do as a starting point...eventually you'll find things you love doing sober and people to do those things with - trust me
Your view of what 'sobriety' will be like is pretty much pure AV. Please recognise that.
You don't have to get through the next 30 years, you just need to get through today
D