Delete test resource projects permanently

What does this MR do and why?

Deletes test projects permanently like we do with groups to reduce buildup of test resources that contribute to problems with blocking deployments.

Also fixes missing deletion failures.

Related to https://gitlab.com/gitlab-com/gitlab-OKRs/-/work_items/5451 & gitlab-org/quality/quality-engineering/team-tasks#2540 (closed)