Fix regression where inserts into reference tables with a different name on sharded keyspaces were not routed correctly.

Fix regression where inserts into reference tables with a different name on sharded keyspaces were not routed correctly. #23898