Add semconv v1.24.0 to `otelhttp` #9064

Job	Run time
compatibility-test (~1.22.0, ubuntu-latest, 386)	2m 19s
integration (test-mongo-driver)	12s
compatibility-test (~1.22.0, ubuntu-latest, amd64)	2m 15s
lint	4m 34s
test-coverage	4m 0s
compatibility-test (~1.22.0, macos-latest, amd64)	2m 55s
test-race	3m 41s
compatibility-test (~1.22.0, windows-latest, 386)	4m 47s
compatibility-test (~1.22.0, windows-latest, amd64)	8m 2s
compatibility-test (~1.21.3, ubuntu-latest, 386)	2m 22s
compatibility-test (~1.21.3, ubuntu-latest, amd64)	42s
compatibility-test (~1.21.3, macos-latest, amd64)	1m 48s
compatibility-test (~1.21.3, windows-latest, 386)	4m 22s
compatibility-test (~1.21.3, windows-latest, amd64)	5m 39s
test-integration	1s
test-compatibility	1s
	47m 40s

Provide feedback