“It wasn’t as big as Guns N’ Roses – but it could have been. It just didn’t last long enough.” A member of one of rock’s most celebrated supergroups says things could have got even bigger if the wheels hadn’t fallen off