Yes he should move to 147.
Not because he will achieve any more at Welter, but because of the money he could potentially earn fighting the likes of Cotto and Cintron.

Ricardo Mayorga at his best was very entertaining but not a great fighter.
This aged, battle scarred version is certainly not going to threaten any title holders, but has enough left to make some nice money for himself and his family.