He's in trouble but I'm not too sure he's finished for now.
Pep has always been able to get out of his problems in previous seasons and although this time the problems are a bit bigger, I still believe he can still turn this situation around for the better.

Now he's in a bit of a pickle where the scheme he's been building since the beginning (even for a few seasons) which has always worked well is starting to suffer from a problem where they're only able to keep the ball without being able to do anything to score because their finishing has faltered due to their targetman being unable to move due to being closed down.

It seems like the opponent has begun to understand how to anticipate Pep's scheme because it always relies on Haaland who has always been a goal robot for Manchester City and when his movement is covered then it is like the end for Pep's scheme. But this can't be the end, now we are faced with the winter transfer where Pep will obviously try his best to select his performance I guess. Rodri's role is quite vital, I think they will try to patch this gap because until now Kovavic has not been able to do it and it is likely that for the winter transfer they will try to find new alternatives so that Manchester City's attack pattern is maximized not only possession of the ball they have in match.