"it hurts me emotionally when he wants to go places and be around people that are clearly part of his disease. "
I've dealing with this issue right now. the only thing you can do is not go to places with him when he wants to go to.
I find it that female bartenders, understand more than male bartenders but I also noticed they don't cut them off when they know they are too drunk.