Evaluate and potentially remove Redis caching code for security widget state
The redis caching code in `CompareSecurityReportsService` causes a lot of bugs so we should evaluate whether it can be safely removed.
#### Background
In !224794#note_3151805582, @bwill noted:
> I think that the frontend actually isn't polling this endpoint anymore to determine if there is security widget data. Since !201475 was merged, we now make a graphql request instead which runs a cheap DB query to check if results are ready. Therefore, I think we can actually delete all this redis code and save ourselves the headache.
#### Tasks
1. Verify that the frontend no longer uses the REST endpoint that relies on Redis caching
2. Confirm that the GraphQL approach introduced in !201475 fully replaces the Redis-based polling
3. Identify all Redis caching code related to security widget state (including `ready_cache_key` and transition keys)
4. If safe to remove, create an MR to clean up the Redis caching code
5. Update any relevant documentation
#### Related Issues
- #592403 - Tracking improvements for security widget state management
issue