Sounds like he's got a lot going on, but the substance(s) gotta go before he can make any progress on anything else.
There are some good dual-diagnosis (alcoholism/addiction and mental illness) programs, and he would probably benefit from one of those.
YOU would probably benefit from Al-Anon.
I think taking a break from the relationship for a bit is probably a good idea for you both. I don't know how "friendly" you can be during that time--he probably needs to focus on his recovery, and you probably need to focus on yours.
People do recover. But it has to be something they really want with all their hearts.
Glad you're here, stick around.