Nikon only recently got mirrorless cameras better than their DSLRs. Canon & Sony have had better mirorrless cameras for several years.
I've got a Sony α7Riv and their 200-600mm f/5.6-6.3 zoom lens for wildlife. Only 10FPS, and slower autofocus (and no bird eye tracking) but still a great setup for the price. I tend to be in forested areas around small ponds, so while I'd love a big prime lens for more light, being able to zoom out actually gets critical since backing up would lead to falling into the water.
zoom lenses are great, especially for the versatility they offer.
Later on the same walk, a Grey Catbird landed right in front of me. Fully zoomed in to 840mm I couldn't even get a good portrait shot showing the head and shoulders, just the head. So I zoomed out and got this[4], which I could easily crop for a good portrait. No need to back up and risk scaring the bird.
Money is one obstacle to a big prime lens (the Sony 600mm f/4 lens is $14,000!), but another obstacle is weight and bulk. I wouldn't want to give up having a zoom lens ready on a camera, to allow for otherwise impossible compositions. So I know I'd end up carrying two cameras, one with a 600mm behemoth and the other with the 200-600mm zoom, and my shoulders would hurt. And they'd be bulky and getting in my way, etc.
Primes are nice, but they're not perfect for every situation, and gatekeeping photographers for not having primes is stupid.
[1] https://www.flickr.com/photos/193634150@N07/52188406196 [2] https://www.flickr.com/photos/193634150@N07/52188661399 [3] https://www.flickr.com/photos/193634150@N07/52187390672 [4] https://www.flickr.com/photos/193634150@N07/52187392882
I ran into some situations were a lens shorter than 24mm would have been nice, and some where something beyond 300 (400 on a DX body) would have been nice. 20mm prime lenses are cheap enough, the telezooms not so much. Currently my preferred one is a Tamron 150-600 G2. Weather sealing is nice, and the Sigma Sport is just too heavy and large, especially since I mostly shoot handheld / without a tripod. Funny so, that the Tamron is much less available used than the Sigma Sport.
And if, if, I had 14k free budget to burn on a lens I would still burn max. 1k on the elns and the reminder on travelling to nice locations where I could use said lens. But then I am no professional.
Fully agree that mirrorless is the future, took long enough to fully get track.
There are some DSLR snobists, there are prime lense snobists, there are mirrorless snobists, there are frame rate snobists.
In the end the picture matters, whatever helps you get good pictures is good for you.
That beimg said, as of now I'd say a Z6ii is still behind a D780 a bit and quite a bit behind a D6 (I'm a Nikon shooter, so don't ask questions about other brands). A Z9 on the other hand... That being said, none of those options beats the one you can actually afford and know how to use.
Edit: Which DSLR (Edit 2: I mean mirrorless...) gets 20 fps? The Z6ii is at 12. Everything above is, what, 5k plus for the body?
Edit 3: That seems to be Nikon's Z9 with 20-30 fps in continous mode. Up to 120 in small JPEG. Impressive, and with 6k Euros almost reasonably priced when compared to other Nikon top mofels of the past. One can still get a Z6ii and a bunch of top notch lenses. Damn, I shouldn't have looked it up...