"The conflicting aspect is I know I should not drink and I should just not do it. "
But you WANT to do it.
Yeah... you don't WANT to wind up on a bender...
but you WANT to drink....
you don't WANT this.... but boy oh boy... do you ever WANT it.
I get it.
Here's the thing; you can choose to WANT to be sober and live a richer life now.... or you can choose to WANT to drink, and eventually find yourself so desperately wanting to NOT drink that you'll have no choice but to fight like mad to get out of it.
Or, at least, that's what happened for a lot of us.
Crap situation, isn't it?
On the upside though, if you choose the harder path right now - wanting to be sober so that you can experience how good life really can be - you may well avoid a whole lot of awfulness and also find a deep happiness much sooner in life.
That may or may not be more important to you than being wasted at a football game.
It's your call.