I have two stories:

1. My dad had the exact same inkling about your age.

Wanted to party, wanted to fuck around, wanted to go to uni and get a real job.
He left his wife and her two kids to do just that. I don't know whether it was worth it to him, I don't really care either.
All you need to know is that right now he's drinking two bottles of gin a day, lost his wife, and his kids aren't talking to him. We're all basically waiting for him to die.

2. I dated a girl for 6 years and left her. Tried to break up with her 2 years in because I wasn't happy and she convinced me to keep trying and I just... kept putting it off. I wasn't miserable, but always knew I wasn't actually happy, but kept thinking "well if it's been this long there has to be *something* there". Eventually I realised that ultimately doing it years down the line would feel exactly as bad as doing it now; so I might as well do it now and save myself time.

Couple of wisdoms I have from these experiences:

Firstly, single life isn't the fuckfest you think when you're in a relationship. You're used to every flirt landing and physical affection (if not sex) on demand. IRL you have to work for it way harder, and honestly likely won't get laid all that much until your next relationship.

Secondly, it sounds like youre unhappy with the way you approach your relationships and I think that's something you should get professional help for. Therapists talk to dozens of people in your situation every day. They've heard it all. If nothing else, you can learn what won't work.

Lastly, whatever you decide to do, you need to fucking commit to it. If you REALLY decide leave your wife, it's for good. Don't hit her up 3 years down the line about how sad you are and you regret leaving. Don't let her talk you out of leaving. You decided, that means it's happening. Sure she's going to be miserable, but if you pussyfoot around and refuse to commit to an outcome you leave her dangling in the wind and she doesn't deserve