The Rodrygo situation remains uncertain. I believe Real Madrid is trying to keep him. They're likely trying to convince him, but if they can't reach an agreement with manager Xabi Alonso, he's likely to leave the club this transfer window. The transfer window is almost over, and the transfers will gradually take shape. Manchester City has a short time to finalize this transfer. They need to convince Real Madrid and the player.
I think Rodrygo will stay at Real Madrid even though he will likely only be a substitute in the future, that's because Man City still hasn't found a clear point regarding Savinho agreement with Tottenham and as far as I know Man City is currently more focused on recruiting Donnarumma, with the transfer window closing soon, it means they don't have enough time to recruit both of them.