I think he absolutely has to leave Real Madrid, it's a team that no longer wants him and isn't interested in having him play, he risks being forgotten and never playing again, I know it's difficult for him but there's a real rift between the club and the player, it's better for him to leave
Moving to another team could be the right choice for Rodrygo at this point, because he is no longer a main option in the Real Madrid squad. Especially after the arrival of several new players, his role has been replaced, and Xabi is still reluctant to give him a more central role and longer playing minutes. If he chooses to stay at Real Madrid, it is likely that he will only end up as a reserve player, which would be quite unfortunate for him. It would be better for him to make the decision to move to another club rather than waste his talent on the bench.