That's horrible but he shouldn't be taking it out on you... Probably the one good thing he has and he could potentially loose that cause if it doesn't change soon you have to get out for yourself, you can't just hold on and hope he gets better, not everybody changes.
His self esteem needs to change and that is hard work, alcohol is getting in the way of that work, he has to face reality at some point or he will die like this.
Something has to click in his head, there's no specific answer for something like this but he's not trying, he's given up, you can't be with someone who won't even try.
I struggle severely with my self esteem, I know what its like to be in his shoes, I used to be an alcoholic.
There's always worse things in this world and hes wallowing in self pity.
The only thing I can think of is getting him to watch shit loads of inspirational and motivational YouTube videos, drill it in to his head until he sees that hes the only one who can change and that it is 100% possible, cause it is whether he believes it at this point or not