Addiction trumps astrology.
His addiction is all about him and has absolutely nothing to do with you. It's not personal.
You cannot love him clean and sober. You cannot talk him clean and sober. You cannot scream him clean and sober. You cannot beg him clean and sober. He owns this one. Only he can decide to get clean and sober and stay that way, or not. It's his choice.
Only you can figure out what is acceptable to you.
Are there children? Is he the financial support of the household? What's in it for you?