`idx_sbom_components_on_name_gin` synchronous database index removal

Summary

This issue is to add a migration(s) to create/destroy the <async-index-name> database index(es) synchronously after it has been created/destroyed on GitLab.com.

The asynchronous index(es) was introduced in Async removal of the idx_sbom_components_on_nam... (!167199 - merged).

Implementation plan

1. Remove the index according to https://docs.gitlab.com/ee/development/database/adding_database_indexes.html#add-a-migration-to-destroy-the-index-synchronously