...
Even though you unlocked the “Ranking”(used as an example) custom field from the database you will not be able to rename the same field in Power Admin as it is still shown shows as ‘locked’‘Locked’.
Error screenshots
The custom field page is showing that the Rank custom field is unlocked from the database.
...