Provide mechanism to disable internal tracing

[sirianni]

The collector is consuming excessive memory from internal spans

For example, the httpcheckreceiver's otelhttp instrumentation is holding on to a decent chunk of memory for its span attributes

There doesn't appear to be any way to opt-out of this behavior https://github.com/open-telemetry/opentelemetry-collector/blob/5309d60a167b7e86e346f8abb845e2cb68c5ed35/config/confighttp/confighttp.go#L225-L236

The collector's telemetry config does not expose options for configuring or disabling the TracerProvider.

There is a long-standing open issue https://github.com/open-telemetry/opentelemetry-collector/issues/6629 to allow for exporting these internal spans. Perhaps providing a way to disable recording of these internal spans would be a simpler start.