In #94290, we saw that locking requests could be issued through a LeafTxn and the lock spans would be silently dropped, leading to delayed unlocking once the locker transaction was committed. We don't support locking requests passed through a LeafTxn, so we should assert against this and return an error to clients that issue such requests.

Jira issue: CRDB-25806