Op similar feelings here. Not with drink driving thank god but I often contemplate if my life would be a lot calmer and easier without the draining and straining behaviour of my dh. 
Our entire marriage has bounced from one thing to another,one obsession over something into another.
Harmful things but so bloody draining al the time.
He also started drinking a fair amount around five years ago now.
Same scenario as in he was with drinking four to five cans every single night for literally months and months to not drinking at all.
The slightest thing would stress him out and that would be it back on it.
This time it's been every single night four five or six pints and sometimes more on a weekend since lockdown began.
Uses it as another excuse.
To be honest it puts me off him
I know this sounds awful but he's so out of shape now and I'm never around him for long before he stinks of booze. 
He says he knows it's not good role modelling for the kids as it's unhealthy etc etc. To me it shows a massive weakness he has when it comes to things.
I deal with all home schooling at present,all the finances including juggling as wages have been down etc etc even though he's been home for 8 weeks.
It's gradually feeling like a dead weight around my neck and like you don't think I've got the energy or enough love to support him through yet another dry run which also involves change of diet to everything healthy and awkward and different expensive drinks and on it goes.
Sorry for the rant. Just you sound so like me right now.
I've had it for years and no matter what I say it doesn't go in or he agrees he can be hard work but doesn't ever do anything about it