Maniacs can be quite profitable to play with, but they can also induce high variance. It can also be pretty profitable to play with somebody who has been drinking, but sometimes it is more annoying than anything. Considering you guys get together only once a week, I can understand people not wanting to play with him in this situation. Nobody wants their Friday night to end early because they were stacked by some idiot who sucked out with a horrible hand.
If he is problematic enough to break up a game, I'd consider asking him to either not come anymore or tone down his drinking. An unpleasant playing style can be tolerated by most if the guy is at least friendly at the table. Pairing a maniacal, game-changing style with a personality soaked in alcohol can be anything but joyous.