feat: update promise and resource status condition when delete workflow is triggered

[richcooper95]

Summary

In #362 we added a DeleteWorkflowCompletedCondition which is (1) currently only used on Resources, and (2) is only updated on Resource Delete workflow failures.

This issue is to address (2) by updating the condition to communicate that a Delete workflow has started, for both Promises and Resources.

[#412 addresses (1) by adding the condition to the Promise status too!]

Details

See #362 for how the condition is used in the failure case. We should update the condition to the following when a Delete workflow has started:

    Last Transition Time:                   2025-03-06T14:48:07Z
    Message:                                Delete Pipeline pipeline-1 is running
    Reason:                                 DeleteWorkflowInProgress
    Status:                                 False
    Type:                                   DeleteWorkflowCompleted