I'm sorry you're in such an upsetting situation. What you're seeing is the progression of alcoholism ... for a while active alcoholics can keep it together but as it progresses they become like your husband.
I'm both a recovering alcoholic (23 years) and codependent. One thing I know is nobody can get an addict to put down his/her drug of choice (in this case booze). It's time for you to take care of yourself and your children. Try to take the focus off the alcoholic and put it on yourself and your family ... here you can make a big difference.
Just let expectations go. Nobody can predict if someone will get sober or continue drinking. Remember that addiction/alcoholism is classified as a mental illness.
God bless.....