Add consumer profiles

[dmathieu]

Description

This adds profiles support for consumers.

Link to tracking issue

Based on the discussion in #10375.

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 92.34%. Comparing base (de8bd27) to head (cd3ef63).

Additional details and impacted files

@@           Coverage Diff           @@
##             main   #10464   +/-   ##
=======================================
  Coverage   92.33%   92.34%           
=======================================
  Files         393      395    +2     
  Lines       18647    18656    +9     
=======================================
+ Hits        17218    17227    +9     
  Misses       1069     1069           
  Partials      360      360           

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[dmathieu]

I believe the failure is unrelated to these changes.

[mx-psi]

@open-telemetry/collector-approvers planning to merge this tomorrow if nobody blocks before then