No definitive smoking gun on alcohol use has yet been presented, but the evidence leans heavily against it. Two very large direct studies and one huge meta study have recently appeared, and they largely point to increased risk of dementia as well as of cardiometabolic disease (includes stroke, coronary heart disease, and diabetes).
No healthy level of alcohol consumption, says major study
There’s no risk-free amount of alcohol, population-level study finds
Alcohol use and burden for 195 countries and territories, 1990–2016: a systematic analysis for the Global Burden of Disease Study 2016
Heavy Drinking Tied to Early-Onset Dementia in French Study
Contribution of alcohol use disorders to the burden of dementia in France 2008–13: a nationwide retrospective cohort study.
Both long term abstinence and heavy drinking may increase dementia risk
Relation between alcohol consumption in midlife and dementia in late life (Editorial)
Alcohol consumption and risk of dementia: 23 year follow-up of Whitehall II cohort study