Stabilize module yamlprovider

[mx-psi]

Before stabilizing a module, an approver or maintainer must make sure that the following criteria have been met for at least two successive minor version releases (regardless of when this issue was opened):

• No open issues or PRs in the module that would require breaking changes
• No TODOs in the module code that would require breaking changes
• No deprecated symbols in the module
• No symbols marked as experimental in the module
• The module follows the Coding guidelines

Please also make sure to publicly announce our intent to stabilize the module on:

• The #otel-collector CNCF Slack Channel
  • https://cloud-native.slack.com/archives/C01N6P7KR6W/p1726568533758939
• The #opentelemetry CNCF Slack channel
  • Cross-posted the message above
• A Collector SIG meeting (if unable to attend, just add to the agenda)
  • Announced on 2024-09-11 meeting

To help other people verify the above criteria, please link to the announcement and other links used to complete the above in a comment on this issue.

Once all criteria are met, close this issue by moving this module to the stable module set.