Pep Guardiola’s tenure at Manchester City has seen remarkable achievements, but recent challenges raise questions about his future.