Delete paired audit event destinations in API

What does this MR do and why?

Delete paired audit event destinations

• When using audit events refactor feature flag

Changelog: added EE: true

• ❗ Once the stream destinations tables (new) are all migrated and fully in use, all of this code will be removed along with the legacy API routes.

References

Please include cross links to any resources that are relevant to this MR. This will give reviewers and future readers helpful context to give an efficient review of the changes introduced.

• #503242

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

How to set up and validate locally

• Follow steps from the Create MR to create destinations: !173752 (merged)
• Destroy destinations via API with the feature flag enabled to trigger 'paired' deletion:

Mutations
  instanceExternalAuditEventDestinationDestroy
  externalAuditEventDestinationDestroy
  auditEventsAmazonS3ConfigurationDelete
  auditEventsInstanceAmazonS3ConfigurationDelete
  googleCloudLoggingConfigurationDestroy
  instanceGoogleCloudLoggingConfigurationDestroy
  instanceAuditEventStreamingDestinationsDelete
  groupAuditEventStreamingDestinationsDelete

Where inputs are the gid like "gid://gitlab/AuditEvents::Instance::GoogleCloudLoggingConfiguration/1"