Pep Guardiola’s side in total disarray after following five straight losses by throwing away a three-goal lead in a 14-minute meltdown