Yes, the General Instruction for the Roman Missal (GIRM) allows for substitutions to be made for the Responsorial Psalm, so long as the replacement still corresponds appropriately to the reading. (That is, the Responsorial Psalm should respond to the Reading it follows!)
61. After the first reading comes the responsorial Psalm, which is an integral part of the Liturgy of the Word and holds great liturgical and pastoral importance, because it fosters meditation on the word of God. The responsorial Psalm should correspond to each reading and should, as a rule, be taken from the Lectionary.
It is preferable that the responsorial Psalm be sung, at least as far as the people’s response is concerned. Hence, the psalmist, or the cantor of the Psalm, sings the verses of the Psalm from the ambo or another suitable place. The entire congregation remains seated and listens but, as a rule, takes part by singing the response, except when the Psalm is sung straight through without a response. In order, however, that the people may be able to sing the Psalm response more readily, texts of some responses and Psalms have been chosen for the various seasons of the year or for the various categories of Saints. These may be used in place of the text corresponding to the reading whenever the Psalm is sung. If the Psalm cannot be sung, then it should be recited in such a way that it is particularly suited to fostering meditation on the word of God.
In the dioceses of the United States of America, the following may also be sung in place of the Psalm assigned in the Lectionary for Mass: either the proper or seasonal antiphon and Psalm from the Lectionary, as found either in the Roman Gradual or Simple Gradual or in another musical setting; or an antiphon and Psalm from another collection of the psalms and antiphons, including psalms arranged in metrical form, providing that they have been approved by the United States Conference of Catholic Bishops or the Diocesan Bishop. Songs or hymns may not be used in place of the responsorial Psalm.
So a “seasonal” Psalm can be used in place of one which the people might not be as familiar with.
Frankly, I think the use of simple melodies for the response is a better approach than substituting one well-known Psalm for another less-known Psalm.