Upgrade to `v1.37.0` semantic conventions

[MrAlias]

Blocked by open-telemetry/opentelemetry-go#7252

• Update otel dependencies to use a commit hash if the packages do not have a tagged release
• Find and upgrade all go.opentelemetry.io/otel/semconv/* packages to use the go.opentelemetry.io/otel/semconv/v1.37.0* equivalent