Pep Guardiola hopes for end to nightmare after the worst losing run of his managerial career