Op what a bloody nightmare 
In the early part of the thread I was geared up to write a massive rant, but thankfully I continued to read all of your posts and I can see how upset you now are. One of the things that stood out to me in the earlier posts was that you both were drinking at dinner, you knew he was drunk and that this is normal around your dc. You didn't find it strange when he disappeared without saying anything and didn't come back, to the point you went to bed and feel asleep, so this is clearly 'normal'.
He drinks everyday whilst off work and once again is soon to become unemployed. It isn't hard to work out what your life will look like then. His job prospects are going to be crap with no license and 2 drink driving convictions under his belt.
This is your future now.
Clearly you need to have a long hard look at what you want. This man appears to have no regard for you, his children, or indeed anyone else.
You indicate that he has always been like this and is now approaching 40. Why would he change now, especially when faced with no employment opportunities for a long time to come?
Anyway, for me there would be no future in this relationship. You need to choose what path you want for you and your children. Sorry if my post seems harsh, it is quite emotive for any of us who have lost someone due to a drink driver.