You are actually right and I also share the same sentiment with you here, Rodrigo has always loved real Madrid just as valvades, he did not wish to leave the club, that's why he hasn't pushed for a transfer away from the club uptil now.
As for xabi Alonso's take on Rodrigo, it's very obvious that he doesn't rate him that much, so moving away from real Madrid is the best possible scenario for him and for his playing career, if not his value as a player will drop even more if he continues staying on the sidelines at real Madrid.
Rodrigo is still quite young and has the opportunity to excel at Real Madrid if he's patient. However, if he wants first-team football, a move to another club is a much better option. Both players truly love the club, but competition for regular playing time is tough due to the high competition from other players in their positions. I would prefer both players find other teams so they can play regularly in the first team. This would significantly increase their value, as they can demonstrate their best qualities and contribute to the team.