I think you know this but if he's going to drink? He's going to drink.
This applies no matter what he says, no matter what his family says, and no matter what you do. It literally has nothing to do with you, and everything to do with his disease. You cannot save him.