Recent pop culture—like Single Drunk Female and the courageous revelations by Cara Delevingne—is inspiring women to examine their hangups around sobriety.