Don't feel bad. He is doing what alcoholics do, moving from one enabler to the next (and there's no shortage of them). It's really all about him, and is not a reflection on you at all.
The goal, now, is to not replace him with another just like him.
Take care,
Cyranoak