Have you tried the Apple Smart Keyboard Folio? It’s significantly lighter while being more flexible, which makes it better for traveling. No trackpad, but the iPad is a touchscreen-first device anyway.(You can always get a mini mouse if needed)I was always a 9-10" iPad user up until the M1, where the miniLED being exclusive to the 12.9", and the KB actually starting to become good, so I gave the larger size a chance. After using it for two years I am already used to this size, with the apparent problems of weight, overall bulk when on Magic KB, but as an in-house device I find it a much better fit than the 11" especially when I need more than a single app / window on screen. Portability does suffer a lot, to the point I frequently just don't want to take the 12.9" with me outside. But that's more to do with the Magic KB than the tablet itself.
Now if the new 11" does get no less good screen than the 13", this formula may change. I also need to see what improvement or changes in ergonomics for the new Magic KB, because on the 11" I found the keys being too crammed compared to the 12.9" has a MacBook size layout with enough key spacing. Weight reduction will be welcome but it will happen to both sizes anyway, and probably will be more significant on the larger model, we saw that with the titanium iPhone 15 Pro Max getting a more meaningful weight reduction than the Pro where you could feel it more on the Max.
The Magic Keyboard is better suited for home, which is where I use mine.