Add semconv v1.24.0 to `otelhttp` #9065

Job	Run time
lint	4m 46s
compatibility-test (~1.22.0, ubuntu-latest, 386)	2m 21s
compatibility-test (~1.22.0, ubuntu-latest, amd64)	2m 24s
test-coverage	4m 0s
compatibility-test (~1.22.0, macos-latest, amd64)	2m 23s
compatibility-test (~1.22.0, windows-latest, 386)	4m 7s
test-race	3m 44s
compatibility-test (~1.22.0, windows-latest, amd64)	5m 57s
compatibility-test (~1.21.3, ubuntu-latest, 386)	2m 25s
compatibility-test (~1.21.3, ubuntu-latest, amd64)	32s
compatibility-test (~1.21.3, macos-latest, amd64)	2m 11s
integration (test-mongo-driver)	17s
compatibility-test (~1.21.3, windows-latest, 386)	4m 30s
compatibility-test (~1.21.3, windows-latest, amd64)	7m 43s
test-integration	1s
test-compatibility	1s
	47m 22s

Provide feedback