“I said, ‘Inform Mr Jagger that the fee is a million dollars.’ He just about choked on that. But he knew the Stones needed us”: Twelve months of chaos, carnage and controversy that turned Guns N’Roses into rock’s biggest band – and nearly killed them