Hate to see you going through this. If you are going to end the relationship, just do it. Now would be a good time. Just say you are done. If you wait till he is sober, it will just be another excuse to get drunk. He is responsible for his own stuff. Let him figure it out.