Allow `rake cache:clear` clearing pipeline status cache

What does this MR do?

Allow rake cache:clear clearing pipeline status cache

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

• We need to update Gitlab::Redis::Cache.with so it's less likely to make this mistake. This is at least a quick fix for this
• Are there other misuses?

Why was this MR needed?

Otherwise rake cache:clear cannot clear pipeline status cache.

Does this MR meet the acceptance criteria?

• Changelog entry added, if necessary
• Tests added for this feature/bug
• Review
  • Has been reviewed by Backend

What are the relevant issue numbers?

Closes #44582 (closed)