Fix Rails/ApplicationController offenses

What does this MR do and why?

Fixes Rails/ApplicationController offenses.

Related to #239356

It looks like the remaining ActionController::Base usages are there for a reason. We don't want to use a load of extra functionality in some controllers. Thus, disable the cop in place for those controllers. That idea was discussed in the thread below.

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.