Controversial goalkeeper heading back to club with tail between legs after failing to secure deadline-day transfer to Manchester United