Revert "Merge branch 'sh-use-access-exclusive-lock' into 'master'"

What does this MR do and why?

This reverts !114363 (merged) since grabbing an AccessExclusiveLock on two large, busy tables is not going to work well: gitlab-com/gl-infra/production#8521 (comment 1310305762)

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.