Is your feature request related to a problem? Please describe.
Currently, the three statuses cancel-requested, pause-requested, and revert-failed are present in the back end code (https://github.com/cockroachdb/cockroach/blob/master/pkg/jobs/jobs.go#L198), but are not enumerated or treated specially in the front end (https://github.com/cockroachdb/cockroach/blob/master/pkg/ui/workspaces/db-console/src/views/jobs/jobStatusOptions.ts#L27). This causes these statuses to have a blue coloring for their badge, even though another color would better convey meaning.

Describe the solution you'd like
Assuming that these statuses are real, I think the following would make sense?
cancel-requested: gray, same as cancelled
pause-requested: gray, same as paused
revert-failed: red, same as failed
@Annebirzin @kevin-v-ngo
Jira issue: CRDB-10868