Do not requeue the indexing worker if failures occur

What does this MR do and why?

Related to #413524 (closed)

Backporting !122100 (merged) to previous stable release

This is needed to prevent customer sidekiq instances from being overwhelmed by Elasticsearch indexer workers (if the indexing is failing). This type of issue is often seen after a major upgrade if the previous Advanced Search migrations were not completed before the upgrade.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• This MR is backporting a bug fix, documentation update, or spec fix, previously merged in the default branch.
• The original MR has been deployed to GitLab.com (not applicable for documentation or spec changes).
• This MR has a severity label assigned (if applicable).
• This MR has been approved by a maintainer (only one approval is required).
• Ensure the e2e:package-and-test-ee job has either succeeded or been approved by a Software Engineer in Test.

Note to the merge request author and maintainer

If you have questions about the patch release process, please:

• Refer to the patch release runbook for engineers and maintainers for guidance.
• Ask questions on the #releases Slack channel (internal only).