Record the failure type by using the OpenTelemetry error.type standard tag instead of the custom nservicebus.failure_type

[mauroservienti]

Describe the suggested improvement

Is your improvement related to a problem? Please describe.

There is no specific problem.

Describe the suggested solution

OpenTelemetry introduced a standard way to report failure types using the error.type tag. When we introduced OpenTelemetry support in NServiceBus, the error.type tag was not a thing, and we decided to use a custom nservicebus.failure_type tag.

It would be good to conform to the standard error.type tag.

Describe alternatives you've considered

1. Option 1: Keep things as is and deviate from the standard
2. Option 2: Introduce the new tag and keep the old one (possibly forever) to maintain backward compatibility, especially considering that there is no easy way to deprecate anything OpenTelemetry-related

Additional Context

No response