As with any addiction, he needs help. I’m sorry you are going through this especially with such young children.
Like what others have already said he needs to attend AA. Even then, it is not foolproof. There has to be will on his side to truly not drink anymore.
Is he going through a rough patch psychologically? Not that it’s a good excuse, but he may benefit from some counseling and psychological assessment apart from AA.
A really good friend of mine in the US once called me up to ask to borrow a whole lot of money roughly $10k due to his gambling addiction. He made it sound dire and I was on the verge of enabling him by lending the money. That is until his sister called me to tell me she had already lent him nearly $100k. His addiction hurt everyone around him. It did strain her marriage as she was a housewife and her husband, while he made good money, basically was funding his gambling habit. She told me, actually urged me, I needed to let her brother hit rock bottom.
I have not spoken to him in years since and I don’t know what happened. What do I know is he lost his first marriage due to his addiction.
It sounds harsh but I think you have two options - 1) let DH hit rock bottom, lose everything for him to realize this is what his addiction has cost him or
2)Be supportive and help him through these issues. It will be difficult, especially, with young children, but it may make your marriage stronger.
One of my closest friends’ father was an alcoholic. She said seeing him as an alcoholic as a kid was difficult. He was erratic in what he showed up for depending on whether he had had a drink or not. His marriage to her mother also failed due to his addiction. When he did show up, sometimes drunk, he’d embarrass everyone including her mother and her.
Again, the odds are long. Only you can make the decision as to what is right for your family.
I’m very sorry for the position you are in. Do think it through and what is best for your family.