I wonder how much of health benefit is just the practice of relaxing with a drink. Stress can really eat away at you and if you find a way to relax with a glass of wine, it's a great thing for your emotional well-being. I would say the same thing about smoking marijuana too, especially if you can get decent weed. That can really help you just calm down after a long day.
In the same vein, I think everyone ought to try psychedelics at least once.
I relax by taking a 3 mile run, so I guess it really depends person-to-person what's best.
I think drinking in moderation is fine, but my opinion is a bit jaded of it due to having several blatantly drunk students come to my class.
A post-run beer would work even better though.
And, I don't see why you need to bring up getting drunk. That's a whole different kettle of fish. I drink almost every day and I've been drunk maybe once in the past 2 years. Some people can't do that, but that's a problem with addictive and immature behavior, not a problem with booze.
And on the other side of the coin, being a teetotaler is a real negative. It's socially detrimental, you lose out on some fun youthful experiences, you lose out on the fun of experimenting with your brain. It's really close-minded to go through life without even trying to experiment with altering your consciousness.