I have little doubt that City will score, because they have no other choice and they have a good attack, but I also think that they will concede, and perhaps more than once. Guardiola has been pessimistic about his team for the rest of this season, and it is difficult to fight such an attitude, especially against Real, who clearly have the goal of winning this tournament again. At best, City can count on a draw in the second leg.
What is the point of scoring goals if they end up losing and that happened in the first leg and Man City took the lead before Real Madrid went on to win the game. The second leg will be at the Santiago Bernabeu, every club knows how difficult it is to play here so the chances of Man City winning the game are slim. Even if Man City do score, I am sure it will not lead to a win.
Man City did not take advantage of the home game to get a win so they had a chance of qualifying and the defeat they got actually made Man City's chances even slimmer. A draw would be in Real Madrid's favour and I don't think there is any point in that, it is better to push for a win even though it is difficult.