Most of us are being hard on the guy, he was drunk and is clearly bitter and frustrated, so he's apologised.
The best thing to do, I think, is to get some hobby/ies where he can meet up with women in a pleasant enjoyable environment doing something everyone concerned really enjoys, and that isn't a bar or club,(where the pressure is on to score, and the feelings of failure inherent probably greatly reduces the chance to actually be successful in his case).
You want to meet attractive women in a nice environemnt? Join a local theatre group, for instance, even if you don't want to perform, you can work backstage - there's always more women than men around in these , and many attractive, fun, inteeligent, sensitive single women go to them.
A ballroom dancing class or group is also probably a good idea, for similar reasons, but heck, any decent club/hobby group, whatever, with pleanty of women around is a good idea, - charities, political groups, etc.
Avoid sci-fi groups, and similara, nerdy, male orientated groups.