Observational research has shown that light-to-moderate drinkers have a lower risk of dementia. But there’s more to the story.