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.
I kinda feel sorry hearing that Alonso doesn’t think Rodrygo fits his style. Before Alonso took over as Madrid’s coach, Rodrygo was working hard helping out Vinicius and they managed to win La Liga and the UCL last season with Ancelotti. It’s not really about competing for spots, Alonso just wants to fix the squad because having too many top players is making the team’s performance shaky and teamwork a bit off. Letting Rodrygo go is what Alonso thinks is the best move, but honestly, I think that’s pretty worrying.