I think for a lot of people, particularly when they are young, the ultimate appeal is the loosening of inhibitions. Not necessarily because you want to do stupid things, but because there are things that you wish you could do when you are sober, but are prevented from doing by your various anxieties. And when you are young, you are very anxious.
However, it is very difficult to maintain a constant level of just-intoxicated-enough over the course of an evening. If you don't keep drinking, you can end up with an early onset hangover which wipes you out for the evening. If you keep going, you are likely to get more drunk than just enough. And once you get more drunk, if you are in a place where you feel safe and with people you enjoy, it can be really fun to be stupid together. Again, having the time to stay up late is something you are more likely to have when you are young and/or single and childless.
And when you are young, you often don't get hangovers unless you drank a lot. So you start out with large benefits and a small downside. As you get older, the benefits shrink and the downside grows. If you are not an alcoholic, you probably just drink less frequently and less at a sitting. If you are still trying to chase the way it used to make you feel, or if you drink to numb your emotional pain, and/or if you have a dependency, then you may continue drinking, to your detriment.
All that being said, I'm not going to speculate on whether our host actually drinks the way he says he does, or whether it is a schtick. Although if he does drink like that, and still somehow manages to read and review three probably shitty modules a week, in addition to earning a living, that's actually kind of impressive, in a horribly unhealthy way.