DependsOn not respected when resource is in DELETE_FAILED state

## Scope of request / Expected behavior

When a resource has a [DependsOn attribute](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-attribute-dependson.html) and is in the DELETE_FAILED state, the stuff it depends on should not be deleted because they may still be needed for cleanup

## 4. Suggest specific test cases

a CloudFormation stack containing:
1. an `AWS::SecretsManager::Secret`
2. a lambda for a custom resource, which always fails on deletion
3. a custom resource which executes that lambda and `DependsOn` the secret

on deletion, the custom resource should fail to delete and the other two should not be deleted

## Category

Management