I'm not sure why Aperture would be dead - both Aperture and iPhoto currently integrate with iCloud, no reason to think the dualism of local/cloud storage couldn't continue. My theory is that iPhoto users will be migrated to Aperture. There are other possibilities.
But if we were to extend the iPhoto/Aperture is dead logic to the rest of Apple's software offerings... who really needs Pages, isn't TextEdit enough? Who needs FCP, isn't iMovie enough? Would closed-systems Apple ditch its "serious" apps and let platform-independent Microsoft, Adobe, and Google pick up the crumbs? Hardly.
Every time something happens on the consumer side (is it "dumbing-down," or "user friendliness?"), pros and serious amateurs consider it a sign that Apple is abandoning the pros. For the most part, that hasn't been the way it's worked. The last "abandonment" I can recall is pro server hardware, and that was quite a few years ago. We still have the traditional line-up of pro applications, we have a brand-new Mac Pro design, MacBook Pro...
Apple has more than one constituency, and it's true that the numbers skew heavily in favor of the masses. Sure, if something had to go, it'd be the smaller niches. The question is whether anything has to go, especially when Apple is as profitable as it is. As long as there's a reasonable justification (trickle-down of high-end R&D, maintaining a pool of "key influencers," etc.), it fits into the profitability equation.
There are few better endorsements than, "This is what the pros use." You can see it in all of Apple's ads - pros doing really cool things alongside amateurs doing stuff that's nearly as cool. Pro usage is "aspirational" for the masses. Canon and Nikon have been using this approach for decades. Still, both Canon and Nikon make their real money on p&s and "serious amateur" gear. Do we worry that the latest Canon p&s is a harbinger of doom?
All Apple is doing is adding a new bottom rung to its ladder. They have no need to remove the top rung of the ladder to make that happen.
The difference is.....we've actually seen new updates in terms of usability and design changes to the iWork suite. We haven't seen squat to iPhoto/Aperture aside from iCloud integration.
Also, read some of the latest reports on Nikon/Canon. Trust me, their not making "real money" in p&s. They are boarding on financial trouble, Nikon more than Canon.