Support Otlp Profiling

Is your feature request related to a problem?

Otlp-Profiling is now in alpha, and we'd like to see SDKs implement support for it, especially for things that the opentelemetry-ebpf-profiler cannot profile or only with very high overhead, such as heap profiling data.

Bonus for supporting process context and thread context (we've looked into this one a little, and 3.14's PyContext_AddWatcher combined with thread-context-sharing should be viable) when they're ready.

The profiling working group would welcome questions or input, and feel free to join the fortnightly call. All information about the call is at the top of our running meeting notes.

Describe the solution you'd like

n/a

Describe alternatives you've considered

No response

Additional Context

No response

Would you like to implement a fix?

None

Tip

_{React with 👍 to help prioritize this issue. Please use comments to provide useful context, avoiding +1 or me too, to help us triage it. Learn more here.}

No files, tests, or entry points are identified. Start by reviewing the OTLP Profiling proposal and the linked process-context and thread-context specification work, then consult the profiling working group for scope and implementation guidance. Done means the Python SDK has an agreed, tested support plan for profiling data and the relevant context features.