What he needs is the help of professionals in the fields of addiction and mental health. There is plenty of such help out there if he can summon the willingness to seek it. That's not something you can do for him.
And please do not convince yourself that you had any positive or negative impact on his drinking at all. If only we were so powerful that our mere presence could cure another person's addiction, this forum would not exist.