Bump go.opentelemetry.io/collector/semconv from 0.51.0 to 0.116.0 in /pkg/translator/prometheusremotewrite

Bump go.opentelemetry.io/collector/semconv from 0.51.0 to 0.116.0 in /pkg/translator/prometheusremotewrite #12260