I know it's hard right now, but when it's time, it's time.
You can bet you will get a raft of apologies and promises AGAIN tomorrow or the next day. He might even go into rehab. Now that he's out, I would suggest you not let him come back unless and until he's been SOLIDLY sober for AT LEAST a year. Getting someone out is the hard part.
I'd suggest you talk to a lawyer about support and custody.