insights: add missing on delete for foreign key

Created by: coury-clark

Fixes #27530 (closed)

Adds a cascade to the insight_dirty_queries FK to insight_series, so that series can be deleted in one operation.