It's possible for any coach if a team is willing to give them a chance for a few seasons instead of just 1 or 2 seasons. Manchester City gave Pep Guardiola many opportunities and they also put a lot of faith in Pep by following his wishes and plans every season, as a result Pep Guardiola really succeeded in proving that.
Every trainer can experience the same thing if they get good support financially and stay longer. At PSG there is a lot of pressure especially because they have set high targets every season in the Champions League. Not a single coach has won that title for PSG yet, but Luis Enrique has a chance to do so if the two things I said are fulfilled by PSG.
It's one thing to give a manager an opportunity to try make up for his mistakes or prove himself worthy and it's another thing for the manager to live up to expectations, for instance Manchester gave Pep chances to prove himself and he did by winning the Premier league which made the to back him up with more funds to get more required players to help him strengthen his team based on the fact that he's lived up to their expectations and fulfilled what's demanded of him.
But there are some managers that even with the right backings and opportunities given to them they won't really have good performance and might even end up making wrong decision that would cause a destruction in the dressing room, so what I'm trying to say is that it takes a good experienced coach with talent like Pep to come into a club and make a difference.