Manager Pep Guardiola said Manchester City's times of greatness are gone after crashing out of the Champions League with a humbling 6-3 aggregate defeat to Real Madrid in the knockouts.