Add subscription for AutoDismissWorker

What does this MR do and why?

Add subscription for AutoDismissWorker

Subscribe the worker to Sbom::VulnerabilitiesCreatedEvent.Executing auto-dismissal based on this event should take care of dismissing vulnerabilities created by:

• Sbom::CreateVulnerabilitiesService
• Gitlab::VulnerabilityScanning::AdvisoryScanner

References

• Worker added in Add `AutoDismissWorker` to trigger based on Vul... (!214531 - merged)

MR acceptance checklist

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

Related to #581377