Move majority of nodejs auto-instrumentation to opentelemetry-js repository

[pavolloffay]

Component(s)

auto-instrumentation

Describe the issue you're reporting

Get rid of https://github.com/open-telemetry/opentelemetry-operator/blob/main/autoinstrumentation/nodejs/src/autoinstrumentation.ts so that the operator uses only supported auto-instrumentation

https://github.com/open-telemetry/opentelemetry-js-contrib/blob/main/metapackages/auto-instrumentations-node/README.md#usage-auto-instrumentation

env NODE_OPTIONS="--require @opentelemetry/auto-instrumentations-node/register"

At the moment the operator uses --require /otel-auto-instrumentation-nodejs/autoinstrumentation.js

[pavolloffay]

The packages that operator uses:

• auto-instrumentations-node - https://github.com/open-telemetry/opentelemetry-js-contrib/blob/main/metapackages/auto-instrumentations-node/package.json#L48
• sdk-node - https://github.com/open-telemetry/opentelemetry-js/blob/main/experimental/packages/opentelemetry-sdk-node/package.json#L46