Remove temporary indexes added for the backfill

Remove the tmp index added in Async tmp index addition for a `vulnerability_o... (!148470 - merged) • Michael Becker • 16.11

---

This work is blocked until the background migration is finalized:

• finalize MR: !158720 (merged)
• finalize issue: #471527 (closed)