Pep Guardiola said he knew the end was near when he felt the energy that had driven him for a decade slipping away