I agree with everything you’re saying about 24mp and loved both versions of the Z6. I thought the low light performance was incredible with that sensor. Having said that, it was $1700. I have the A1 and for a brief time owned the Z9 and both are great cameras. I never shot either of them at the maximum frame rate and most likely never will. If the A9iii were $4-4500 range it might be tempting to me but I think the price is insane and that’s only my opinion. You’re right in saying larger than 24mp isn’t needed a lot of times but it’s pretty darn nice to have. The A1 is most likely the highest price I will ever pay for a camera during my life and it’s still more capable than 99.9 percent of the photographers out there myself included. I’ve fallen for the trap numerous times over the years by feeling like I always needed the newest model. I’m at a point in my life that I plan on keeping things much longer and becoming more proficient in using them. I think Sony will have to drop the price of tge A9 to sell more, just like they did with the A7RV but that is just my opinion.I find the idea that 24-25 megapixels is not enough is not really true. I like being able to pair a high resolution 46 MP camera with a standard resolution 24 MP camera. There are plenty of times when larger photosites for better low light performance would be better. There are times when 24 MP is all you need even for a large print - and 24 MP upsizes very nicely. And for volume work, smaller files from a 24 MP camera are quite nice. My next camera will be a 24 MP camera - and I've already sold my Z7ii with plans to get a Z6iii to pair with my Z8. Even if I need to crop, the quality of the image from a 24 MP camera supports cropping moderately and still resulting in great images for prints.
The big advantage you have with a 24-25 MP camera is smaller files - which are faster to process, faster to write to a card, and longer to fill a buffer. If you want a fast camera, this is one of the first tradeoffs I'm willing to make.