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.
Rodrygo is still young and possesses excellent individual qualities, so it's fitting that he join a team that can give him a starting spot and further develop his career.
At Real Madrid, it's already been very difficult for Rodrygo to secure a starting spot due to the fierce competition for attacking positions, and he also doesn't seem to fit into Xabi Alonso's style of play.