chore: Removed all non-paging alerts.

This is step one before I move whatever of these are useful into mimir.

Removed all alerts that don't page.

Part of gitlab-com/gl-infra/scalability#2584 (closed)