Sync writes to new audit events table

Background

As part of &13370 cells migration, we will need to split our audit_events table into 4 new tables:

1. user_audit_event
2. project_audit_event
3. group_audit_event
4. instance_audit_event

The objective of this issue is to enable write of audit events into new tables.

Proposal

We currently do database writes using auditor https://gitlab.com/gitlab-org/gitlab/-/blob/master/lib/gitlab/audit/auditor.rb?ref_type=heads and it writes to audit_events table, we need to enable the writing of events into new tables also.

We also need to fix #441092 (closed) while migrating old data.