Expand the failure category reporting to most of the CI/CD jobs we run

Problem Statement

In Map CI/CD failures to failure categories (#512594 - closed), we are pushing failure categories inside RSpec CI/CD jobs. Failure categories will help us understand the CI/CD failure distribution, and which ones should be prioritized for biggest impact on pipeline stability.

There are many more jobs that could fail than RSpec jobs, and we are not mapping them to failure categories.

Goals

Expand the failure category reporting to the majority of CI/CD jobs

Exit Criteria

• 80+% of failing CI/CD jobs are mapped to a failure category

Technical considerations

I now created Failure categories - Ensure we have the full jo... (#538809 - closed) as a follow-up of this MR.