Alcohol in moderation is good for your long-term health. But even that depends on the type of alcohol that you consume. Beer certainly isn't. Wine is, and whiskey to an extent.
But for an athlete, there's no point in giving a s*** about what's going to happen to you at 60 because your career is too short.
Any alcohol consumed causes dehydration and will affect many things like your sleep pattern, which is why the top athletes don't drink any alcohol during their season.
I'd submit that fairly infrequent alcohol consumption is good for immediate psychological wellbeing, for a lot of people, anyway.