ctest: Restore enforcement of RESOURCE_LOCK test property

Refactoring in !8995 (merged) accidentally broke RESOURCE_LOCK. Fix it and replace the previous test with one that would have caught this.

Fixes: #25843 (closed)
Backport: release