I'm not read up enough on the literature to have a strong take on whether moderate drinking has some slight health benefits compared to abstaining (the J-shaped curve) or whether that's a statistical illusion, but this is a fairly balanced and informative take on the question.

The Great Alcohol Health Flip-Flop Isn’t That Hard to Understand—if You Know Who Was Behind It
More than 30 years ago, the "French paradox" got America bleary-eyed.
slate.com