[Feat]: sp-dialog-wrapper to render sp-alert-dialog, at least the error variant

[lehelen19]

Code of conduct

• I agree to follow this project's code of conduct.

Impacted component(s)

sp-dialog-wrapper

Description of the requested feature

Since <sp-dialog> with the error attribute will be removed in the future, we should support the transition from <sp-dialog> to <sp-alert-dialog> in the cases that <sp-dialog-wrapper> should render the error variant of the <sp-dialog>.

Right now, if we have <sp-dialog-wrapper error></sp-dialog-wrapper> and leverage its other properties, we are not as easily able to transition to using an <sp-alert-dialog variant="error"></sp-alert-dialog>.

Mockups or screenshots

No response

Implementation notes or ideas

Draft PR with example: https://github.com/adobe/spectrum-web-components/pull/4909/files