There is a difference between an occasional user, who will use 3-4 times a year in his vacations and someone who is an addict who can't control himself and is on crack all the time.
If its the latter, as you say, then no, I agree the guy shouldn't be mayor.
Nobody knows about his crack situation, but we know for a fact that he's drunk all the time. The guy clearly has consumption problems whether it's food, alcohol, and he makes smoking crack look like a one time thing.
Sorry but one doesn't just "happen" to smoke crack when they are drunk. You have to put yourself in a situation where it could happen.