REF/block the implicit cast of datetime.datetime to pa.date32()
- [x] closes #58420
- [ ] [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).
- [ ] 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.

The change I made probably doesn't change the entire problem because the code continues to cast all other pyarrow types.

Really appreciate the research into this @PedroVerardo . From what you discovered the issue is upstream in pyarrow - I copied you on the issue there so let's close this and track upstream.

Sorry there is nothing to merge into pandas but once again thanks for your efforts on this