insights: fix issue where records were not set as failed if they exceed max retries

Created by: coury-clark

Closes #24219 (closed) Closes #24203 (closed)

Fixes a bug where records that should be terminally marked failed are left in errored state because there is a condition requiring the record be processing to update the row.