Rodrygo is indeed a very good player, as has been proven, but securing a starting spot is very difficult due to the fierce competition in Real Madrid's attack. Therefore, it would be better for Rodrygo to move to another team, as it would be in the best interests of his future career.
Rodrygo is still quite young and has a long career ahead of him at Real Madrid. If he is patient and continues to improve individually, I'm sure he will gradually earn his starting spot, although there are many rivals for a key role at Real Madrid. Xabi Alonso's journey in the Champions League will certainly be challenging, as many teams are now starting to make changes to strengthen their teams in the competition. The first season won't be smooth sailing, as Xabi Alonso may need to adjust.
Rodrygo should not gamble with his career, he understands that it is very challenging for him to get a place in the Real Madrid starting XI now, but if he wants to stay at Real Madrid, it could have a bad impact on his career. As far as I know, Real Madrid has told Rodrygo to find another club, if this news is true, then Rodrygo should go to another club because a club tells a player all these things when the club has no plans for that player. Even then, if Rodrygo loves the club and wants to stay at Real Madrid, he may have to sit on the bench for the whole season and if he sits on the bench for the whole season, his demand and market value will decrease a lot. If he thinks well about his career, Rodrygo should move to a good club in the Premier League if he has the option.