It sounds to me like your value system is set strongly against drinking. To try to maintain a relationship with someone who drinks will bring you pain. It would be unfair/unrealistic of you to expect him to change. Either you need to change your value system, probably not a good idea, or you need to leave this relationship.
No hard feelings need be conveyed. Its just incompatible. Like if one of you wanted to have children and the other did not.