Value Scripts that change the field type are broken

In #45395 we changed values source resolution to prioritize field type when we could, but this breaks the case where a user wants to use a value script to change the type of the underlying field, e.g. replacing a number with a string.