You did very good, telling him the truth. That might make him think, but if we say sure I will be here for you, then out they go to drink as you will forgive and be there. Not cruel or heartless, just tough love.
If he asks again, perhaps say, it is too insane to live through, when NO ONE can help them except a perfessional or AA people.
Hope you stand your ground, best for you both.