Run migration tasks against both dbs

What does this MR do and why?

Resolves #386436

This drops :main from the migration tasks we run in CI for all EE jobs and adds gitlab:db:lock_writes before migrating.

Tested in db:check-schema and db:check-schema-single-db from !108151 (closed)

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.