I don't know if Real Madrid can return to the levels we are all used to. Let's always remember that the path will be tough and tortuous. It's not easy to deal with players who are used to being prima donnas and who can't understand that many times when they are removed from the team it is for the good of the club. I'm a bit sorry for Rodrigo, but I think it's necessary for him to find himself in another team.
I'm also surprised that Real Madrid is opening the door to a player like Rodrygo, even though he's still very young and can still be relied upon in attack, even though they already have several better attacking players. But Real Madrid can still use him when other players suffer mid-season injuries, as happened last season, which hampered Real Madrid's consistent performances in La Liga and the Champions League. And if Madrid can't keep Rodrygo next season, the player could find another team willing to take him, especially teams in the Premier League or Serie A.
With his deployment to Real Madrid, he won't find hard finding another team that will get him. But on the note of having him in Real Madrid, I would say, the team have seen his potential and now there are news articles stating that he's about to leave Real Madrid for real
(Rodrygo AGREES to leave Real Madrid and confirms which club he wants to join). He's now in the middle of decision whether Liverpool or Arsenal. Or maybe, which team has a very good compensation offer given the fact that he's in Real Madrid for quite some time.
6 years with Real Madrid is no joke so he has great bargaining power what team to join next.