[processor/resourcedetection] Add support for profiles signal

[mx-psi]

Component(s)

processor/resourcedetection

Describe the issue you're reporting

This processor would be useful for testing and validation of the experimental profiling signal, and to replace some functionality available in the eBPF Agent.

As inspiration for how to add support this PR can be used: open-telemetry/opentelemetry-collector/pull/11071 (there is no processor with support as of the writing of this issue)

Example of configuration using profiles (needs service.profilesSupport feature gate to be enabled):

receivers:
  otlp:
    protocols:
      grpc:
exporters:
  otlp:
    endpoint: ${OTLP_ENDPOINT}
service:
  pipelines:
    profiles:
      receivers: [otlp]
      exporters: [otlp]

[github-actions[bot]]

Pinging code owners:

• processor/resourcedetection: @Aneurysm9 @dashpole

  See Adding Labels via Comments if you do not have permissions to add labels yourself.