docs(python): warn about scan_pyarrow_dataset's limitations and suggest scan_parquet instead (if possible)

docs(python): warn about scan_pyarrow_dataset's limitations and suggest scan_parquet instead (if possible) #6474