Update the span attributes to follow the latest semantic conventions

[minimAluminiumalism]

What problem do you want to solve?

We are still use some deprecated trace attributes like MESSAGING_URL in the kafka instrumentations.

opentelemetry-python-contrib/instrumentation/opentelemetry-instrumentation-kafka-python/src/opentelemetry/instrumentation/kafka/utils.py

Line 133 in 4a1e0ce

SpanAttributes.MESSAGING_URL, json.dumps(bootstrap_servers)

Additionally, we are also using some deprecated attributes, such as NET_HOST_PORT and NET_PEER_PORT, in our database instrumentation.

Maybe we should update them to follow the latest semconv.

Describe the solution you'd like

Just update them to the latest semconv like changing MESSAGING_URL to server.address and update the test cases as well.

Describe alternatives you've considered

No response

Additional Context

No response

Would you like to implement a fix?

Yes