Barcelona also seems interested in signing Rodrygo. However, I doubt they'll be successful. They'll have to compete with Arsenal and Liverpool, who are also reportedly interested in the player. And we know Barcelona still faces financial problems. So, I think the chances of signing Rodrygo at this point are slim. Real Madrid themselves will only let Rodrygo go if the offer is good enough. Otherwise, they'll keep him. However, Rodrygo still seems comfortable at Real Madrid and seems ready to stay, even if his playing time is likely to be limited. However, I don't think it will be easy for Rodrygo at all, as he now faces even tougher competition within the club.
Moving to a rival club usually has some consequences. The fans see it as treachery, and they can be hostile to such players. Rodrygo shouldn't even consider moving to Barcelona because it might not be pleasant to the fans and even the management. Some clubs include a clause that restricts players from signing for rivals or even clubs in the same league, as was the case with Victor Osimhen. Liverpool or Arsenal should be the Brazilian's best options.
Fans have to take player's for what they actually are, to a player a club is just a platform to showcase their balling talents and that is what matters to them and the revenue that comes from that is the salaries, so when the player knows that they're day's on the club are no longer profiting, they definitely will look for other clubs to move to and fans shouldn't crucify them for doing what make them relevant in the scene, emotions have nothing to do with reality.