'Well, we all know that time is going to take us rockers, but when the giants fall, it's really hard to accept,' he said on stage