[C++][Python] `cast` with timezone-aware array inconsistent when casting to `timestamp` and `date32`

### Describe the bug, including details regarding any error messages, version, and platform.

```python
import pyarrow as pa
import pyarrow.compute as pc
from zoneinfo import ZoneInfo
from datetime import datetime

arr = pa.array([datetime(2020,1,1, tzinfo=ZoneInfo('Asia/Kathmandu'))])

print(pc.strftime(arr.cast(pa.timestamp('us')), '%Y-%m-%d'))
print(pc.strftime(arr.cast(pa.date32()), '%Y-%m-%d'))
```

This outputs:
```
[
"2019-12-31"
]
[
"2020-01-01"
]
```

So, when casting to `timestamp('us')`, it seems that PyArrow keeps the underlying timestamp the same but just reinterprets it in UTC

But when casting to date, it does it according to the local time zone

I don't know which one is right, but I'd have expected them to follow the same logic

### Component(s)

Python