[azure-core-tracing-opentelemetry] Adopt OpenTelemetry HTTP semconv 1.23.0

[lmolkova]

Update HTTP attributes to comply with HTTP semconv vTBD (likely 1.23.0 will declare them as stable):

1. Rename attributes according to docs:
   • http.method -> http.request.method
   • http.status_code -> http.response.status_code
   • net.peer.name -> server.address
   • net.peer.port -> server.port
   • http.url -> url.full
   • http.user_agent -> remove
2. Add new attributes:
   • error.type - some error-code or a full exception name if exception happens. Also includes status code (as string) for responses we consider to be an error. Maybe we can steal something from .NET - https://github.com/dotnet/runtime/blob/main/src/libraries/System.Net.Http/src/System/Net/Http/Metrics/MetricsHandler.cs#L157
   • http.request.resend_count - try count
3. Update HTTP span names according to the new conventions
4. Check if there is anything else in the list of changes that needs attention

[lmolkova]

Fixed in #34089