Removes prometheus_alert_id column on alerts table

What does this MR do and why?

Removes prometheus_alert_id index on alerts table

This MR is a follow-up from !162630 (merged)

After this one we'll drop a column in a separate MR.

References

Screenshots or screen recordings

N/A

How to set up and validate locally

N/A

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.