[Security Solution] [Detections] Replace rule status saved object

[dhurley14]

Same as: #91265

Describe the feature:

With the addition of #82401 (issue: #79785) We now have the ability to record executionStatus errors to the event log and most likely no longer need the rule status saved objects. I think it would be in our best interest to start removing references to this and hopefully move to only using the event log for managing error history and current status.

[elasticmachine]

Pinging @elastic/siem (Team:SIEM)