Potential regression induced by #57347

[DeaMariaLeon]

PR #57347 May have induced a regression.
Benchmark:
frame_methods.AsType.time_astype (Python) with copy=False, from_to_dtypes=('float64[pyarrow]', 'float64[pyarrow]')

@phofl

[phofl]

This is overhead that is generated by the warning that is raised now, so closing as expected.

We should get back to the original runtime by removing the copy keyword