Add support to configure Prometheus' Tracing

[ArthurSens]

What is missing? Tracing was introduced to Prometheus in version 2.18.0, using the Jaeger library.

Jaeger's lib was deprecated and has finally been sunset so it didn't make sense to commit support for something that was definitely going to be replaced.

In version 2.34.0, Prometheus changed its library to OpenTelemetry, and with it a lower likelihood of changes. Maybe it is a good time to add support to the operator as well?

Why do we need it?

Prometheus users might need to collect traces to troubleshoot Prometheus.