If he is embarrassingly drunk and making a fool of himself.....you DO NOT have to take responsibility for him....let him take responsibility for himself....take care of yourself, leave him where he is and let him wake up wherever....
maybe he will realize what he is doing sooner rather than later.