Whether it’s figures of public renown in music, film, politics or history, or private – mentors, relatives and even lovers, this week we look into songs about how the once admired and revered can seriously disappoint and fall from grace