So sorry that this has happened again. I know how you might allow yourself to hope and that goes down-the-drain quickly.
According to your post, it appears that he may not have been working a program or had a sober support system (AA/NA/sponsor/etc).
Do what is best for you and your kiddos. You sound very strong.