Would you get behind the hire if there were clauses in the contract that addressed his alcohol issues?
The only thing such clauses could address would be any potential buyouts if he has to be fired. That's only part of the problem. What about the negative effect on the team if he has to take a leave of absence and go into rehab, or has to be fired? No contract clause can fix that problem.
I'd just like some assurance that he really has his alcohol issue under control.