[v8] Use OpenTelemetry for Node performance instrumentation

[mydea]

In v8, @sentry/node should use OpenTelemetry under the hood for performance instrumentation.

This is currently implemented in @sentry/node-experimental. This package should be discontinued in v8, and instead the performance handling part should be merged into @sentry/node.

Note that this also includes actually testing all the integrations - currently, auto instrumentation is not really tested (because OTEL only allows to test this in E2E tests, afaik).

Tasks

Beta Give feedback

1. Write integration/E2E tests for node-experimental auto instrumentation #9907
   11 of 12
   +0
   
2. Migrate from node-experimental to node

Open questions

• For ESM users need a loader. We need to document/test/etc this.
• What are the effects for Meta frameworks like next, sveltekit, astro? We need to test this.