There are many great songs, but the one that first comes to my mind is Merle Haggard/Willie Nelson's Reasons to Quit.
Maybe there's also a list here of movies about alcoholism/addiction? So many good ones. Days of Wine and Roses, Requiem for a Dream, Who's Afraid of Virginia Woolf...