Generally speaking, this is as designed. The record in xf_user_profile is a cache value and may contain references to profile fields that are deleted.
There isn't anything in the UI that would display these values (as that is driven by the profile field definitions). If you are writing custom code, you need to be aware of which profile fields are valid.