Hang in there.
Coming here to talk it through is a good idea.
Your wife being on board with you and being honest enough to know her limits is important.
She can still help you hold the line, whilst you can talk things out here.
It is early days, you have time to come up with a plan for your friend, but it sounds like you need to decide now that drinking with him isn't something you are going to do.