Poor bugger. Can't see him lasting much longer; he acknowledges that he should stop drinking - but he can't.
His Management should not be allowing him to do anything but getting professional help. If he refuses that then he still shouldn't be allowed to give personal appearances.
There's only one way this is going to end.