Yeah, converting it to gpkg sped it up a lot, thanks!

I assumed that since geojson is completely unsuitable for querying directly, it would load the whole thing into a native in-memory format, but perhaps not.