[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
- [ ] https://github.com/getsentry/sentry-javascript/issues/9907
- [x] 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.