[Bug]: Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting.

### What happened?

I ran a job with Google Cloud Dataflow with `MongoDbIo.Read` as following

```
MongoDbIO.Read inputIO = MongoDbIO.read()
.withUri(config.getMongoDBUri())
.withDatabase(config.getDatabase())
.withCollection(config.getCollection())
.withBucketAuto(true);
```

However the job failed with error `Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting.`

Typical solution would be using `allowDiskUse` which seems to be applied in MongoDBIO for Go SDK according to #25013 Is this an oversight on Java SDK?

### Issue Priority

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

### Issue Components

- [ ] Component: Python SDK
- [X] 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