“There was something romantic about splitting up when we did. But we couldn’t have gone on anyway. We were killing each other”: How rock’s most volatile band wrote the song that invented the 1990s – and then imploded