The original grind appealed to people because it was hard and there wasn't anything you could do about it. It felt like an accomplishment.
The business side of the house wants a wide net so appealing to those people alone isn't enough, except that those are their core people who have paid their salaries. The faltering I believe is in part due to trying to continually grow and appease shareholders.
CoD seems to be doing fine so big business AAA games will still live on. Blizzard might pivot to doing something like this. I just believe big business is completely incompatible with the cult-like attraction of Blizzard's original IP.
It’s hard to say when peak appeal occurred as WOTLK had peak subscriptions, but slow growth. If anything Vanilla, BC, or WOTLK was the peak appeal and it’s just been down hill after that. Though their are plenty of ways to slice and dice the numbers.
Personally, the Warlords of Draenor mission grind was interesting for a little while, but completely killed my interest in the franchise. Which I think is a central issue for long running games, you can drive people away vastly easier than you can pull them back.
The long term economics of video games is therefore tough, as surviving to tomorrow often means driving people away forever.