First of all, i stopped fuckin with friends that couldn't hold their liquor...thats just drama waitin to happen. People who get drunk and fight all the time means they have issues that need to get dealt with when they are sober.
Secondly, you shouldnt HAVE to firght any loved ones for ANY reason....thats ehy they are considered LOVED ONES. You are supposed to fight your ENEMIES. I have NEVER got into a fith with a friend or family member to the point of fistacuffs. If had to, then we werent friends, period.
Thirdly, i have been in a position where a friend made a stupid drunk mistake. I told them to get their act together or fuck off. Its a wrap. I literally have about 3-4 people i care to even hang out with on a routine basis, because they are mature adults that can handle their alcohol and don't delve into drama filled nights of drunkenness.
Just give him another shot and see what happens. If something similar happens again, tell him to fuck off and move on with your life.