In my opinion, Rodrygo should stay at Real Madrid, he should be more patient, the league hasn't started yet and it seems to me that the new coach is still experimenting with the squad to have a definitive formation and players who will always be the ones to start the game. He probably still wants to see what the best position is for Rodrygo and Viciniu Jr. because both of them haven't been able to score goals consistently.
I believe his experimental period is currently at the World Cup. So, if Rodrygo isn't getting much playing time in this competition, I believe it's a sign that he's not a priority for Xabi, the Real Madrid manager. So, given this, why would Rodrygo stay at Real Madrid? Even if he persists and is patient, he'll likely fall out of favor with Xabi. So, in my opinion, if Rodrygo has a strong desire to move, I think he should. This indicates that he's no longer comfortable at Real Madrid, and even if he's forced to, I believe the results will be less than ideal. Therefore, it's better for Rodrygo to leave Real Madrid, especially with the transfer window still open, so he can find a team that needs him.
In fact, according to current reports, Rodrygo is being targeted by three major teams: Arsenal, Manchester City, and PSG. So, with this in mind, Rodrygo can simply choose which team to join in this transfer window, eliminating his worries at Real Madrid. If he remains adamant about staying at Real Madrid, he'll likely lose focus, as his mind will be constantly reeling. So, in my opinion, Rodrygo should try joining another team so he can further develop and gain experience. And the impact would be even better if Rodrygo joined a team like Arsenal or Manchester City, he would definitely be a key player.