People get tired of public health recommendations constantly flip-flopping (health effects of butter is another).
Then comes media, sees "X causes blood cholesterol to rise, cholesterol is bad, so X is bad" which is a deeply flawed conclusion. Most things aren't universally bad (high blood pressure is bad, but if you raise your blood pressure through exercise that actually lowers blood pressure in the long run), and many negative effects are offset by positive effects not looked at in the study. I wouldn't read too much into anything that isn't a metastudy and took less than a decade to test.
I think the current consensus about red whine is somewhere along the lines of: red whine is good for you, the more you drink the more that effect is offset by negative effects of alcohol, but in the amounts that were always recommended (about 1 glass a day) it's not a huge factor.
But of course those are the harmless examples, there's also interference from industry groups interacting with the current publishing environment (see the whole "fat is bad for you" that we had going for decades for no good reason). So there is a lot of room of improvement.
It's such a big part of culture that people who never drink often have a specific reason not to.
> The lack of objective confirmation of actual amount of alcohol consumed, lack of information concerning alcohol intake before baseline, and inclusion of ex-drinkers with never drinkers in the non-drinker category, as well as lack of assessment of drinking patterns place reservations on the observed findings.
That and those sorts of food studies tend to be bullshit marketing pushes to drive consumption in the first place.
The sigh is because the result is trivial, or because it should be a priori false?
Billions drink alcohol and coffee, so whether any "amounts of" them are good or not is important to study.