I have a couple of Macbooks (one is older and doesn't have much battery life left and lives as a desktop, the other gets used as a laptop) and an iPad Pro with Magic Keyboard that also gets used without the Magic Keyboard.
To me my devices are complementary and I use them all for completely different purposes.
Macbooks are used for multi-tasking, things that require a proper file storage system (synced to Onedrive so that it's available across all my devices), Microsoft Word/Excel/Powerpoint creation and editing, and other things that the iPad is terrible for.
iPad with the Magic Keyboard gets used in various places in the house. The Magic Keyboard on its own is a bit of an overkill (could do with cheaper keyboards) but it is a extremely pleasant user experience with regard to connectivity/etc and is great to type on. I've also used/owned other keyboards (regular keyboard folio, a Logitech folio, and also just a random external bluetooth keyboard) and found I much preferred the Magic Keyboard.
iPad in tablet mode gets used for other things (reading, note taking/highlighting with Apple pencil, watching shows, reading books, casual web surfing).
For my usage I definitely couldn't live with just an iPad with a Magic Keyboard, it's too hard to do things like Word/Excel/Powerpoint on it. And the file storage system on the iPad would drive me nuts.