Create RemoveCatalogResourceComponentsPathColumn post migration

What does this MR do and why?

Parent issue #441666 (closed)

Child #450388 (closed) - this is a continuation task from the parent issue.

This issue is dropping the path column on catalog_resource_components table as per https://docs.gitlab.com/ee/development/database/avoiding_downtime_in_migrations.html#dropping-columns guidelines.

The column was marked as ignored here !147115 (diffs)

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

Run rails db:migrate and see that migration has been successful.