fix: updates labels to include units in metrics

What does this MR do?

• Updates config/prometheus/common_metrics.yml so that the labels include units
• Updates config/prometheus/cluster_metrics.yml so that the labels include units
• Adds migration to query and update existing metrics

Please view the issue's discussion for reasoning about the approach.

Does this MR meet the acceptance criteria?

Conformity

• Changelog entry
• [-] Documentation created/updated or follow-up review issue created
• Code review guidelines
• Merge request performance guidelines
• Style guides
• Database guides
• [-] Separation of EE specific content

Closes #59325 (closed)