S3 Checkpoint loading from URI

[eracah]

What does this PR do?

Allow checkpoint loading for S3 without having to create a load_object_store

What issue(s) does this change relate to?

fixes CO-1144

Before submitting

• [x] Have you read the contributor guidelines?
• [ ] Is this change a documentation change or typo fix? If so, skip the rest of this checklist.
• [x] Was this change discussed/approved in a GitHub issue first? It is much more likely to be merged if so.
• [ ] Did you update any related docs and document your change?
• [x] Did you update any related tests and add any new tests related to your change? (see testing)
• [x] Did you run the tests locally to make sure they pass?
• [x] Did you run pre-commit on your change? (see the pre-commit section of prerequisites)