All or Nothing thinking is a stock in trade for alcoholics, isn't it?
You don't have to 1.) Go on road trips or 2.) Never talk to him again.
Put some boundaries on the relationship. "I would love to spend time with you, but I cannot be around you when you are/have been drinking."
That boundary is for you. Not for him. Stick to it.
You can still be friends with him. Just don't put yourself in dangerous situations, like going out of town with him, or allowing him to be the driver when/if you go somewhere. I have friends who drink. When they do, I'm not around. Doesn't mean they are bad people, and who knows, maybe your sobriety will begin to look attractive to him.
In the meantime, pray for him.