Update breaking changes banner

What does this MR do and why?

This MR updates the breaking changes banner in security policies to be more specific about new_dismissed being deprecated only for scan_finding rules.

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Screenshots or screen recordings

Related to #461697