Remove mandatory notification from metric removal process

What does this MR do and why?

Changes Metric removal process to remove mandatory notification for removing metrics that do not have a performance_indicator_type to simplify the removal process further. Notification stays mandatory for performance indicator metrics

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #430944 (closed)