Even people who never exceed the recommended limits for alcohol consumption are likely to experience brain health problems as they age, a new study suggests.