Just going to leave this here as a counterpoint, since sibling comments feel one-sided on the question:
https://pmc.ncbi.nlm.nih.gov/articles/PMC6957093/#:~:text=In...
Also if you continue to read that meta-analysis beyond the sentence you linked to it seems that much larger studies did not find a correlation between reduced dementia risk and moderate alcohol consumption. In fact they found that high alcohol consumption was associated with significantly higher risk of dementia. The overall conclusion of the analysis was "Available epidemiological studies are not sufficient to verify a protective effect of alcohol on dementia development."