He doesn’t recommend the RSV for Mass — just noting that it is the best English translation. He also notes there is a Catholic edition of RSV.
If I recall correctly, the RSV-CE meets the requirements set by Redemptionis Sacramentum to be used in the Lectionary, though I don't think anyone uses it.
The Protestant community by and large rejected the RSV in favor of the NIV translation or the existing KJV.