Let me ask this... Which rides in WDW represent the best technology could offer at the time or theming so great that it blows people away. The truly great rides?
Haunted Mansion 1969/1971
Small World 1966/1971
Carousel of Progress 1967/1975
Pirates of the Caribbean 1967/1973
Space Mountain 1975
Splash Mountain - 1989/1992
Tower of Terror - 1994
Soarin 2001/2005 WDW
Fully Functioning Expedition Everest? (Does it still count with the broken Yeti?) 2006
Toy Story Midway Mania - 2008
What is missing? What needs to be removed?
Highlighting the word themeing, because of course that's what makes a Disney E-ticket attraction an E-Ticket.
Haunted and Pirates are the most complete soup to nuts Disney E-ticket attractions that still exist. There is not a flaw in their execution from a "Disney" perspective.
Not a single other attraction you list falls into that category.
And let me be clear, to me, it was with Pirates and Haunted that Imagineering and Walt perfected the Disney Themed E-ticket attraction. These 2 are the best of the best. Everything before them was an evolutionary step to them.
Carosel of Progress and Small World come close, but they are prequels in my mind as I said.
Space Mountain and for that matter Big Thunder are excellent Disney Coasters. I have a hard time putting them with Haunted and Pirates, because of what they are, not due to execution.
Splash mountain... We had a lot of arguments about Splash over the years. It's probably the best Eisner era attraction in WDW. It does not however match or exceed the standards set by Pirates/Haunted.
Tower of Terror comes damn close. I want maybe an extra minute or 2 of "story" before the drops start. It's a good attraction in a weak park though.
DCA's version is horrible though.
Soarin is an awesome D ticket attraction. And it's themeing is adequate for DCA. It doesn't meet the requirements for E-ticket stardom. When set in the context of Epcot though, its simply not up to snuff at all. People should be offended that they just dropped that in there without even a different movie.
Expedition Everest is a Joke. Not worth mentioning.
Midway mania. Not an E-ticket, so not up to those standards. Fun though.
The Safari ride is a frickin joke on all fronts. The animal enclosures pale in comparison to San Diego Wild Animal park and the "story" is a punishment.
Rock N' Roller Coaster is just a coaster. My chief complaint here has more to do with what they've done to the studios than any specific problems with the attraction itself, but then, true Disney means those interactions with the park at large matter.
Of the still existing attractions, the only ones you missed are Hall of presidents which isn't up to Pirates/Haunted and Star Tours which at the time of opening was incredible but needed to be updated in the early 90s and wasn't.
Beyond that, all of the attractions that would be up to Pirates/Haunted standards were in Epcot and have either been removed or altered in such a way as to be ruined.
Horizons of course met the Pirates/Haunted standards. It withered and died. Spaceship earth came very close, but subsequent changes have cheapened the experience. Universe of Energy wasn't quite up to Horizons, but it was unique. And of course that trifle of an attraction "Journey into Imagination" is near the top too.
Of course not one good thing has been done to Future world since the Health Pavilion was installed. Everything since then has been a step down in quality.
If you expand to attractions not at WDW, then Indy at DL is quite possibly the modern equivalent of Pirates/Haunted.
Some would say it loses points for being a 3rd party (at the time) property and for that matter being a movie tie in, not a true original and I'm sympathetic to that view, but setting those aside, it is by far one of the best attractions Disney has done.
And of course there's Disney Seas, but I'm not familiar enough to express an opinion about any of that.