People write comments like this often and I'm always wondering if they are just expressing that the device isn't for them or they don't think the device is for anybody.
There are so many devices out there that you can probably find the perfect thing for you. For some of us, the iPad Pro is a great choice.
Most of the people I see making the comments are round-about asking "what can I use to justify getting this, I want one."
I still feel that way about iPads in general, I keep wanting (and even buying) them, but never really do anything with them that I can't do with my phone.
The iPad and Surface are *everywhere* in education and healthcare. Just yesterday I donated blood on a mobile health unit entirely ran on iPads and verizon hotspots. Every k-12 and some high ed sysadmins can tell you about having to manage iPads and JAMF at some point.
I guess OP's question is: If you need a million layers, and gigantic amounts of CPU and RAM, why aren't you working on a desktop workstation? I also had a hard time believing there's a real niche that tablets fill, but hey, they've been with us for years, so clearly somebody's buying them.
People sometimes don't like to be working on creative stuff sitting on a workstation all the time, having hardware that allows to do it on-the-go, or easily move to other places can help to spark something.
For purely technical editing a workstation is probably unbeatable but if you need to find inspiration there's very few things less inspiring than sitting on the same desk, within the same environment, day-in and day-out.