Resolve "Cascade soft delete of core entities to queue"

What does this mr do?

See #598 (closed) for desc.

Does this MR meet the acceptance criteria?

• I have added a changelog entry to reflect the significant changes I made.
• Tests were created to test the feature.
• I have updated the documentation accordingly.
• I adhere to the style guide.

Closes #598 (closed)