[R] Passing a large dataset to duckdb and back results in memory being used and not freed

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

I'll flesh this out with a proper reprex later; the dataset in question is the data from the Voltron Data S3 bucket

```
nyc_taxi <- open_dataset(here::here("data/nyc-taxi"))

nyc_taxi %>%
filter(year == 2019) %>%
to_duckdb() %>%
mutate(mean_distance = mean(trip_distance)) %>%
to_arrow() %>%
filter(trip_distance < mean_distance) %>%
count() %>%
collect()
```

I'm seeing 22Gb of RAM usage here despite the returned result only being 1 row

### Component(s)

R