Summary:
Enable running pg isolation tests that require advisory lock support, which were previously disabled because advisory locks were not supported. With advisory locks now enabled by default, the following tests are activated to improve test coverage:
```
nowait-4
nowait-5
skip-locked-4
```

The remaining advisory lock–dependent tests are still disabled due to current test issues and will be revisited later:
```
test: lock-committed-update
test: lock-committed-keyupdate
tuplelock-update
insert-conflict-specconflict
multiple-cic
```

Jira: DB-17076

Test Plan: ./yb_build.sh --java-test 'org.yb.pgsql.TestPgRegressAdvisoryLock#testIsolation'

Reviewers: pjain

Reviewed By: pjain

Subscribers: rthallam, ybase, yql

Differential Revision: https://phorge.dev.yugabyte.com/D44729