For many, drinking alcohol becomes more complicated in midlife. Here are ways to navigate this sudden shift.