Resolve "Add a rubocop that forbids `redirect_to` inside a controller `destroy` action without an explicit `status`"

What does this MR do?

This MR adds a rubocop rule to check if a method redirect_to is used without explicitly set status in destroy actions of controllers.

Are there points in the code the reviewer needs to double check?

Yes. This new cop has found 48 offenses in already existed controllers.
Should they be fixed?

Does this MR meet the acceptance criteria?

• Changelog entry added, if necessary
• Documentation created/updated
• API support added
• Tests
  • Added for this feature/bug
  • All builds are passing
• Conform by the merge request performance guides
• Conform by the style guides
• Branch has no merge conflicts with master (if it does - rebase it please)
• Squashed related commits together

What are the relevant issue numbers?

Closes #31840 (closed)