Drop project_repository_states table

What does this MR do and why?

This MR drops the project_repository_states table. The application no longer uses the table since %16.9 via !143695 (merged).

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.

Related issues

Related to #426649 (closed)