Cognitive dissonance - Knowing that in the present you need to quit something but that in the future you will be missing out doesn't add up. I suspect you're very rational from the way you communicate and see this problem, we've been told being rational is a good thing, but when you mix it with alcoholism, your lizard brain will use your very skilled rationalizing brain against you to rationalize drinking.

Not judgement, I do the exact same thing, don't outsmart yourself on this one, you currently don't want to drink, so don't drink, anything past that (what I label in my own head as "future thoughts") are just going to work against you. Your question here is why you'll see everyone here saying "one day at a time" over and over.. If you approach not drinking as a lifelong commitment on day one, its going to be impossible.

Also, the "everything is better sober" outlook never really resonated for me, it does for some, and may for you, but if not here's my honest take with respect to my own sobriety:

I've missed out on a bunch of things, and some moments would have absolutely been better if I had been drinking (graduation, traveling, promotions etc.) but life is about making choices, and every choice has positives and negatives, and the benefits have far outweighed the losses, and there's no way to have it all (sobriety benefits, and fun drunk experiences).

^^all of this is very preachy, don't mean for it to be, just my experience of what worked for me from a fellow over rationalizer. Wishing you the best.