Replace local execution with wait for checkpoint execution (MystenLab…

…s#19629)

## Description 

This PR replaces active local execution with waiting for checkpoint
execution.
There are some cleanup needed later to remove all the local execution
code, but we can do that separately.

## Test plan 

CI

---

## Release notes

Check each box that your changes affect. If none of the boxes relate to
your changes, release notes aren't required.

For each box you select, include information after the relevant heading
that describes the impact of your changes that a user might notice and
any actions they must take to implement updates.

- [ ] Protocol: 
- [ ] Nodes (Validators and Full nodes): 
- [ ] Indexer: 
- [ ] JSON-RPC: 
- [ ] GraphQL: 
- [ ] CLI: 
- [ ] Rust SDK:
- [ ] REST API:

Merge branch 'MystenLabs:main' into main

Update docs/content/guides/operator/sui-full-node.mdx

Reverted a change that was already fixed.

Merge branch 'main' of github.com:MystenLabs/sui