Implement AWS managed agentless collector for Prometheus metrics

[RAMathews]

This PR implements AWS-managed scrapers. Prometheus metrics will be scraped directly by AMP, with higher availability, security and scalability. ADOT will still remain for OTLP traces, metrics and cross {region, account} scenarios

• [ ] Docs update
• [ ] Limitations (cross region and account)
• [ ] Provide choice between managed scrapers and full ADOT (enable variable)

What does this PR do?

Added AWS managed collector resource and prometheus configuration. Edited opentelemetry collector configuration to remove some of the prometheus scrape jobs.

Motivation

Implement this new feature: https://aws.amazon.com/about-aws/whats-new/2023/11/amazon-managed-service-prometheus-agentless-collector-metrics-eks/ in Observability accelerator.

More

Currently testing this setup in my local account.

• [ ] Yes, I have tested the PR using my local account setup (Provide any test evidence report under Additional Notes)
• [ ] Yes, I ran pre-commit run -a with this PR
• [ ] Yes, I have added a new example under examples to support my PR (when applicable)
• [ ] Yes, I have updated the Pages for this feature

Note: Not all the PRs required examples and docs.

For Moderators

• [ ] E2E Test successfully complete before merge?

Additional Notes