You can't live like this. I know because I've been there myself. No matter how much I tried to just ignore his stupidity and go to sleep, I lay there dreading the key in the door, or worse, the phone call. Occasionally the bloodied nose (as he was a twat when drunk and wound people up), or the night in the cells. And then dealt with the fall out the next day (or three) as he was incapable of doing anything.
Even if he did come home at a reasonablish time, there was always that smell of him in the bed next to me... booze and fast food seeping out of his pores... I almost had a panic attack recently when I had to sit next to someone who smelled like that on a train. I split with my ex almost 4 years ago!
I'd love to be able to give you some practical advice on how to stop him doing this, but the only suggestion I have is to stop picking up the pieces. Make him deal with the consequences. It's his turn to be up with the kids - make him do it (go out if necessary). Make him clean up any mess. No picking him up in the middle of the night, washing sheets and clothes ruined, don't cover up for him socially. If he's been drinking, he sleeps in the spare room/downstairs/at a mates. I don't go out and get hammered because I know I'd have to deal with it afterwards, with a hangover. Your DH gets away with it other than a row every so often. This is obviously worth it, in his mind.
Other than this, all you can do is take care of yourself first. Get counselling and antidepressants if you need them. Harden your heart a bit and arrange things so that his drinking doesn't impact on everyone else (this is hard, I know, as it feels like you're saying I don't care if you drink too much, I'm not going to get upset and bothered by it and change all my plans for you). Only your DH can actually change his drinking habits, hope he does so before he loses you all.