Poor you. Your husband is an arse.
I'm glad you didn't lie to the police, you would just have made yourself look stupid, and you'd have been enabling him. Drink driving is pretty low in my book too and I think you should be relieved that he didn't crash into people and injure them. Hopefully he learns this lesson without anyone innocent having to be injured.
Now, practicalities. Yes, he'll lose his licence. That is a good thing. Do you share a car? If not and he has his own then sell it, because I get the feeling that your DH might just drive anyway.
If he has a very long journey to work on buses and trains, then this is good. That is his punishment for risking innocent people's lives (more than once). Don't bail him out by driving him there yourself and making all his inconvenience your inconvenience.
I would maybe think about leaving if he doesn't agree to quit drinking completely. But for today just spend the day with your DC and be grateful nobody was hurt (as much as it doesn't feel like it, that was some very good fortune). Nothing much will happen tomorrow so just take care of yourself and try to relax
for you though, getting caught up in this.