It boggles the mind that Apple can't be bothered to support MacOS on the iPad Pro w/ the Magic Keyboard.
...and that would work fine
as long as the magic keyboard was attached so you could use the trackpad to move the MacOS pointer around. Problem is, full MacOS is a long way from being usable with a touch screen, so you'd need to switch back into "iPad OS" mode to use it handheld. You might get away with operating MacOS with a pencil.
That's not a fundamental problem, and it may even be the long-term goal - but it would need quite a bit of work to make MacOS touchscreen-friendly and even more work by application developers to offer both pointer- and touch-based UIs. When you get into the UI design there are a lot of subtle differences in the affordances of touch vs. pointer, and the original iOS vs. MacOS principle was that it was better to have two distinct products optimised for the different interface than one compromise. Bear in mind that
one of the problems with the flop that was Windows 8 was it tried to be both a touchscreen and pointer OS (and that's not entirely solved with Windows 10/11).
It's a bit out of date now, but years ago I put my iPad in a keyboard case - and a few months later wondered why I wasn't using my iPad any more. It had turned a great handheld device into a rubbish laptop. Now, since then iPad OS has improved its keyboard & pointer support & the magic keyboard has acquired a trackpad so that's improved but I still think that if you
want a laptop, a laptop is better.
...and, of course, you can pretty much get a MacBook Air and a non-pro iPad for the price of an iPad Pro and Magic Keyboard & use each of them for what it is best at - and Apple
have been working on seamless inter operation between iPad and laptop/desktop. OK, you have to take two bottles into the shower ...but if you're old enough to get that reference you'll probably also remember carrying around the likes of the G3 Powerbook and 90s cellphones & not see carrying two modern thin-and-crispy devices as a chore.
I think the problem with the new range is that the iPads Pro sound cool (but spendy) but there's nothing particularly new and exciting about the more affordable models that are closer to the original iPad price point.