This is not a question that a MacRumors thread can answer. The people who don't want/don't care about/can't afford the iPad Pro will tell you that it's not worth it. The people who appreciate the extra features and power that the Pro has will tell you that it's worth every penny.
I'm in the latter camp. I use my iPad Pro for absolutely everything, and was even fortunate enough this year to have the dough to move up to the 12.9" model. I have always loved the ProMotion screen, the quad audio, and the extra RAM and processing power. I use my iPad for productivity, creation, and consumption, so I'm always going to buy the best one I can afford.
That being said, I don't think it's necessary to pigeon hole any one iPad model into any one use case or type of user. I know lots of people who don't really do any intense computing in general and still buy the Pro models. They either just really love iPads and want the nicest one possible or they really like their media to look and sound the best it can without worrying about any slowdowns in performance for the foreseeable future. It's perfectly ok to buy a Pro even if you strictly use it as a tablet for media consumption. On the other hand, I still know a handful of people that are happily still using their iPad Air 2 from years ago.
All that being said, I would not be surprised (if rumors of a re-designed iPad Air are true) for Apple to do the following:
--Discontinue the 11" iPad Pro and replace it with the redesigned, slightly lower priced 11" iPad Air 4.
--Update the 12.9" Pro to a micro LED display and make that the only Pro model, design remains the same
--Continue spec bumping the base model with no design/price changes
--Continue spec bumping the iPad mini with no design/price changes
If the new iPad Air really takes on the same design and dimensions as the 11" iPad Pro, I have a feeling that sales of the 11" Pro are largely going to be cannibalized by the 11" iPad Air. It will all depend on internal sales data that none of us have. Apple may see value in keeping both around, or they may see more logic in just having one 11" size to remove confusion from the lineup.
One thing I do know though--an iPad Air redesigned to look like an iPad Pro does not mean it's "just as good". It might be just as good in all the main functionality, but there are reasons the Pro is called the Pro, and in my personal opinion, those reasons are not negligible and are worth the extra money I pay for the Pro.