Add all InfluxDB metrics to prometheus

What does this MR do?

Adds all existing InfluxDB based metrics to prometheus. Due to some concept mismatch the translation is not 1:1 but should give the same abilities to diagnose the internal state of the app when processing the data.

Additionally this MR removes some unused functionality from within internal metrics framework.

Are there points in the code the reviewer needs to double check?

Why was this MR needed?

We are moving towards pull metrics model with Prometheus, this MR allows us to transition from Influx to Prometheus.

Screenshots (if relevant)

Does this MR meet the acceptance criteria?

• Changelog entry added, if necessary
• Documentation created/updated
• Tests added for this feature/bug
• Review
  • Has been reviewed by Backend
• Conform by the merge request performance guides
• Conform by the style guides
• Squashed related commits together

What are the relevant issue numbers?

Closes #33643 (moved)