[Bug]: streaming is set to True in PipelineOptions but condition is evaluating as false for is_streaming_pipeline

### What happened?

On line https://github.com/apache/beam/blob/master/sdks/python/apache_beam/io/gcp/bigquery.py#L2030

```
if not is_streaming_pipeline and self.with_auto_sharding:
raise ValueError(
'with_auto_sharding is not applicable to batch pipelines.')
```
I have set streaming=True in PipelineOptions. I can see the same in dataflow UI. However, when I use with_auto_sharding=True, I get raise with ValueError. So somehow, is_streaming_pipeline is set to False even though I am setting streaming=True in pipelineOptions.

### Issue Priority

Priority: 2 (default / most bugs should be filed as P2)

### Issue Components

- [X] Component: Python SDK
- [ ] Component: Java SDK
- [ ] Component: Go SDK
- [ ] Component: Typescript SDK
- [X] Component: IO connector
- [ ] Component: Beam examples
- [ ] Component: Beam playground
- [ ] Component: Beam katas
- [ ] Component: Website
- [ ] Component: Spark Runner
- [ ] Component: Flink Runner
- [ ] Component: Samza Runner
- [ ] Component: Twister2 Runner
- [ ] Component: Hazelcast Jet Runner
- [ ] Component: Google Cloud Dataflow Runner