[Core] Deprecate and remove core-http-compat

[xirzec]

Now that we are moving all code generation to TypeSpec, the time has come to deprecate our support for "Core v1" by removing the @azure/core-http-compat package and all dependencies on it. This will create some breaks in the SDKs that currently use it, but we should absorb that work during the TypeSpec generation.

Steps:

• Remove dependency from Storage packages
• Remove dependency from AppConfig
• Remove dependency from Search
• Remove dependency from Metrics Advisor
• Remove core-http-compat package from the repository
• Deprecate the core-http-compat package on npm