[Security Solution] [Detections] Register action to fire when failure occurs in rule executor

[Security Solution] [Detections] Register action to fire when failure occurs in rule executor #49670