He's an alcoholic and substance abuser. He has not worked in 5 years.
Given you have two very young children at home, what about this situation is acceptable to you?
You can't fix or save him. He's going to do what he's going to do, regardless of what you do or not.
Put the best interests of your children first. The rest will follow.