He will be back. Acoholics and abusers are dependent people.Even if they just need us to dance the dance of alcoholic/codependent.
Use this time to play the tape through. Play it through till where your children are grownups and ask you where the healthy role models were (like my children are doing with me now)
You have the power (although you are traumatised now) to be/become a healthy role model. Even if you do not feel like that right now - just WANT to be the best role model you can be. Want it badly and trust your HP. He will support you and the children.
Hugs and lots of love from me