[cmd/telemetrygen] add support for profiles

[haoqixu]

Component(s)

cmd/telemetrygen

Describe the issue you're reporting

Add support for profiles to telemetrygen to support profiles in e2e tests.

related: #35999

[github-actions]

Pinging code owners:

• cmd/telemetrygen: @mx-psi @codeboten

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

[mx-psi]

@dmathieu is there any way we can do this today?

[dmathieu]

With rather simple data to reduce the amount breaking changes?

[mx-psi]

Ideally, yes :)

[dmathieu]

Actually, as I'm looking at this, it appears to be tricky to do.
There is no OTLP exporter for profiles, because the only location that does this export is the eBPF agent (the otel-go SDK doesn't handle profiles, and isn't meant to).

[github-actions]

This issue has been inactive for 60 days. It will be closed in 60 days if there is no activity. To ping code owners by adding a component label, see Adding Labels via Comments, or if you are unsure of which component this issue relates to, please ping @open-telemetry/collector-contrib-triagers. If this issue is still relevant, please ping the code owners or leave a comment explaining why it is still relevant. Otherwise, please close it.

Pinging code owners:

• cmd/telemetrygen: @mx-psi @codeboten @Erog38

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