Add descriptive error message for SSA Patch delete for required fields

[lblackstone]

Hello!

• Vote on this issue by adding a 👍 reaction
• If you want to implement this feature, comment to let us know (we'll work with you on design, scheduling, etc.)

Issue details

Based on finding from #2104

In that bug report, the user was unable to delete a DeploymentPatch resource that had force-overwritten a required field. While this is expected behavior for SSA resources, it is likely to be a common point of misunderstanding that we could address with a descriptive error message that explains how to resolve the problem.

There are a couple options, depending on the use case:

1. Set the retainOnDelete resource option, which will leave the resource unchanged and drop it from Pulumi management during a pulumi destroy operation.
2. Transfer ownership of the field to another controller prior to the pulumi destroy operation.