Fix project destruction failing due to idle in transaction timeouts

When deleting associated records, Rails loads all associations into memory (https://github.com/rails/rails/issues/22510) before destroying them. This can cause a surge in memory and cause destruction of objects to fail due to idle in transaction database timeouts. This fix is inspired from https://github.com/thisismydesign to destroy has_many relationships in batches.

Closes #44610 (closed)