Summary:
Transition TSLocalLockManager lock calls to use the async functionality introduced in https://phorge.dev.yugabyte.com/D42862
Jira: DB-16723

Test Plan:
Jenkins

./yb_build.sh --cxx-test object_lock-test
./yb_build.sh --cxx-test ts_local_lock_manager-test
./yb_build.sh --cxx-test pg_object_locks-test

Reviewers: amitanand, zdrudi, rthallam, #db-approvers

Reviewed By: amitanand, #db-approvers

Subscribers: svc_phabricator, ybase, yql

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