Deprecation of prometheus-adapter

[simonpasquier]

From kubernetes-sigs/prometheus-adapter#701

We want to deprecate the project in the near-future, post-triage, and suggest users to fulfill their use-cases using KEDA.

When the deprecation materializes, kube-prometheus should probably stop installing prometheus-adapter by default.

Related to #2475

[github-actions]

This issue has been automatically marked as stale because it has not had any activity in the last 60 days. Thank you for your contributions.