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.
Same thing I've been saying, it's better for Rodrygo look for another club, that's why I wasn't happy his rumoured move to Arsenal didn't see the light of the day. The problem at the moment is that, Real Madrid has put a caveat on a high sale price on the youngster and a lot of clubs are skeptical with their approach. Staying at Real Madrid has already made him a reserver because most of the games comes in from the bench even while Ancelotti was incharge.