I had a friend like this...
Then he started doing jiu-jitsu where he can spar with people all day long.
He is a lot calmer now. (But he still get pissed if you push him a little)
So, yes, aggressive gay sex works.
One of my mates used to be like that. It was a pain in the hole going anywhere with him if drink was involved. Either he was asking girls to get their "tits out for the lads" or he was attacking a bouncer or random stranger in a pub. He got his ass kicked a few times and ended up in trouble with the law for assault before adding 2+2 and decided to quit drinking. Insecure lunatic aggression problem solved, plus he finally got a girlfriend so now he's like a dog that got neutered that still manages to have sex on a regular basis. Much happier chappy:)
Go up to your friend when he is sober, and beat the **** out of him, but in a supportive...nice way
When he comes to explain to him that this is what will happen to him if he starts trouble on your nights out again
Yep - I've got a very similar mate, how the hell he hasn't been arrested more than he has I don't know. His problem (and it could be the same with your friend) is that he has mental health problems that the drink brings out and he flips. He has now recognises this and does something about it (does'nt drink and is on meds).
Difficult bit is getting someone to recognise that they have a problem. Good luck with that one.
Best thing to do I reckon is don't go boozing with him and if you do carry a small club to smack him on the back of the head with if he gets leary.