So to clarify: It’s a matter of gear ratio. The smaller you can get your smallest cog in the back, the faster you’ll be able to go. It’s usually not a concern for most people on most bikes, because A) we’re not monsters like those elites and pros and B) something like a 40 ring up front and an 11 smallest cog in the rear is plenty fast for gravel riding. Using it for road, or simulated road, and for training, it would be ideal to get a faster ratio–either a bigger ring in front, or a smaller cog in back. (Road bikes will come with much larger front rings for that reason.)
That said, most cassettes will have an 11 as the smallest cog, like yours. That’s because 10t cogs are fairly new, and won’t fit on standard hubs. I think most trainers are going to come with the same standard (HG) hub. The smallest cog you can get on those will be an 11. You can get a cassette with a 10t cog (like a 10-42 for example), but those need different freehubs (the part that the cassette slides onto). I don’t know of any trainers that come stock with a hub that will take a 10t cog. You’d need to get either an ‘XD’ hub (SRAM) or a Shimano ‘microspline’ hub.
I know bikes more than I know trainers, so you’ll have to check to make sure that whatever trainer (Zwift Hub or other make/model) can take one of the other kinds of hubs. If it can, then you’d buy the trainer with the HG hub, you’d buy the new (XD) hub, buy a cassette with a 10t cog, buy a new chain most likely, and you’d be off and running. Other people here will know better which trainers can take an XD or microspline hub. And you’re running SRAM, so sticking with SRAM and the XD hub will be a bit more preferrable (although SRAM and Shimano can often be mix-and-matched).
What I’d maybe do is this: find a trainer that can take an XD hub. It’ll likely come with a more standard HG hub. Put your normal cassette on, with your current 40t chainring, and use it that way. If you find you need more speed on the flats or downhill, you could go to a new hub/cassette later on.
You could also get a bigger front chainring. But you’d have to contact Niner to see how big you could go. Their website lists ‘NA’ as the maximum chainring size, which is unhelpful But increasing the size of the chainring in front will do the same as decreasing the rear cog size. There will be a max size you can go, so Niner will have to tell you that.
All that aside–nice bike My wife has a Niner RLT and absolutely loves it. It’s too small for me to really ride, but when I zip around on it after doing some maintenance to test ride, it’s fun.