BUG: Remove `read_json` datetime deprecation warning
- [x] closes #59511 (Replace xxxx with the GitHub issue number)
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [x] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.


CIs are failing, not sure if this is the right target branch to open a PR @lithomas1 - am I right in guessing that there is likely not to be any more releases from the `2.2.x` branch? If that's the case, this PR should target `2.3.x`.

@KevsterAmp - CI issues are likely temporary. Gotcha, retargeting to branch 2.3.x @rhshadrach - moved it to 2.3.x. Do I need to add any other changes here? Thanks @KevsterAmp - can you merge main to kick off the CI again @KevsterAmp - looks like the CI failures are related. Oops, merged the wrong branch