[ASP.NET] Migrate to native Activity Status and Status Desc

[vishweshbankwar]

Fixes 3112

Changes

Please provide a brief description of the changes here.

For significant contributions please make sure you have completed the following items:

• [x] Appropriate CHANGELOG.md updated for non-trivial changes
• [ ] Design discussion issue #

[codecov[bot]]

Codecov Report

:exclamation: No coverage uploaded for pull request base (main@27bac99). Click here to learn what that means. The diff coverage is 85.71%.

Additional details and impacted files

@@           Coverage Diff           @@
##             main     #651   +/-   ##
=======================================
  Coverage        ?   77.78%           
=======================================
  Files           ?      171           
  Lines           ?     5158           
  Branches        ?        0           
=======================================
  Hits            ?     4012           
  Misses          ?     1146           
  Partials        ?        0           

Impacted Files	Coverage Δ
...OpenTelemetry.Instrumentation.AspNet/SpanHelper.cs	75.00% <75.00%> (ø)
...umentation.AspNet/Implementation/HttpInListener.cs	88.31% <100.00%> (ø)