My xh sounds similar to your dp. He worked hard all week and would spend all weekend getting drunk with his mates. Like you I stupidly thought that would magically change when we had kids, it didn't.
I stayed for the kids but eventually had enough of basically being a single mum and having to put up with his crap too. I gave him an ultimatum of either stopping drinking or he was being kicked out and he flat out refused to stop drinking, the next day all his belongings were packed and he moved out.
My advice would be to have some counselling preferably with your dp, although nothing will change until he realises that he has a problem. And don't have kids with him UNTIL he stops drinking , unless you are prepared to pretty much be a single mother.
Sorry to be so blunt but I think you really need to hear the truth.