I think he needs to find the answers within himself, rather than depending on changes in his environment to do it for him.
It's your life, and you have to decide what's best for you, but if you want to help him I think you need to plan stress relieving activities to do with him. He sounds like he is a very anxious person who keeps going to alcohol at the first sign of trouble. Give him something else to go to if you can.
It's a sad story, but I hope it has a happy ending for you. I've seen spouses get through it though, so don't give up if you still want to try. Good luck.