Welcome, lots of good people here who will rally around you.
I do understand that your children have suffered due to your codependency and your husbands drinking. I was raised (more or less) by an alcoholic mom who put her drinking, boyfriends, husbands before her children, and, all of her significant others were drinkers. It was awful, it left scars on me that I am still dealing with today.
As for the minor children, they must come first. You are focusing too much on him and his problem, while problems are festering with your children, these need to be addressed now.
If he contributes nothing what do you need him for? That is the question I would ask myself.
Take care of you, take care of those children, him, let him take care of himself, he is an adult, and, needs to be addressed as such.