Locking in the property tax rate is a reasonable policy for reasons you explain. But it should not have been extended to non-residential, non-owner-occupied properties, and also it should not have been transferrable.
But, being non-transferrable would exacerbate the low-turnover problem by preventing those retirees from downsizing for fear of a big property tax increase.