In the moment? Put him to bed. Tell him he’s too drunk and he’s causing problems, acting inappropriately and put him to bed. Tomorrow, explain what happened, if he’s not immediately remorseful hit him with the “Are you proud of your actions? Trying to touch my cock in front of my family?” be explicit. Explain that is unacceptable and if that’s how he’s going to act while drunk, he can’t drink that much around your family. Set these firm boundaries.

If he’s a decent man, he’s gonna feel really regretful. You can explain you still love him, you still wanna be with him, you understand people get drunk and make bad decisions and ask him if he wants help metering his drinking and try to work out some code phrases to remind him to pace himself while saving face. Revelling drunks hate to be told “Slow down” or “Haven’t you had enough?” Something like touching his shoulder and saying “Whew, these drinks are strong! I think I’m gonna get a buffer water, do you want one, honey?”

Also, get him a Gatorade before he goes to bed and one for when he wakes up, that should help the hangover in a big way. Any electrolytes will do. I like the Brode pills.