Remove `mr_event_rule_pipeline_spec.rb`
Justification
As discussed in #1533 (comment 1271346296), this spec is considered a candidate to be removed as it is a workflow that gets tested regularly already daily. If this rule breaks then we'd know quite quickly.
Edited by Richard Chong