Migrate Pyroscope tracing to opentelemetry

[simonswine]

Is your feature request related to a problem? Please describe.

Pyroscope tracing is based on jaeger client and opentracing, which are deprecated.

Describe the solution you'd like

• Migrate to opentelemetry.
• Being consistent between Mimir, Loki and Tempo (hopefully sharing the same code)
  • Tempo introduced opentelemetry tracer support (optional) in http://github.com/grafana/tempo/pull/842
  • Dskit has introduced support in Support for OTel tracing dskit#681

Describe alternatives you've considered

Nothing else considered.

[callpraths]

This looks to be a dupe of #4127