Enable cop Lint/RedundantCopDisableDirective in grace period

What does this MR do and why?

This MR enables 👮 Lint/RedundantCopDisableDirective in grace period which means that new offenses are silenced in CI on master.

Contributes to #369268 (closed).

Refs #375674 (comment 1118671103).

How to set up and validate locally

bundle exec rubocop --parallel

# Note: Using --only does not work with this cop :'(

MR acceptance checklist

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

• I have evaluated the MR acceptance checklist for this MR.