Based on my personal experiences with my 1st husbands DUI, I agree with Naive.
Remember:
You did not Cause this
You can not Control this
You will not Cure this
The day after at my house was filled with eggshells. I didn't know how to act and neither did he. I didn't understand then about alcolholism. I understand more now. Now I understand that I needed to keep more of my focus on myself and my children than worrying about how my adult partner was going to cope with the fall-out.
He can find the resources, information, and strength to ask for what he needs. This is his opportunity to do the next right thing.
Keep coming back to vent, and ask for the support you need during this time.
You are important!
We care about you!