Geo: Remove transaction lock in `ProjectRepository`

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Label this issue

This tracks step 4 of the implementation plan mentioned in the parent issue, and follows the Milestone 3 plan from the docs:

Milestone 3:

Remove the advisory lock by removing the prevent_concurrent_inserts ActiveRecord callback method. This milestone must be after a required stop.