Support SDK authentication mode for Azure SD and remote-write

[simonpasquier]

Component(s)

Prometheus & PrometheusAgent

What is missing? Please describe.

See https://github.com/prometheus/prometheus/pull/13099

It requires Prometheus >= 2.52.0

Describe alternatives you've considered.

No response

Environment Information.

Environment

Kubernetes Version: Prometheus-Operator Version: