Released in 1992, November Rain by Guns N’ Roses became a cinematic rock opera, marking a pivotal moment in music history