If you can keep them cool and steady enough, spinning disc drives will store more for less and last longer. That is why they will be around for a long time, especially in datacenters. However, if you want them to move and fit tight spaces, then SSDs are far better.
Time is money, and SSDs are usually much faster for end systems. I have two desktops and a laptop with SSDs that boot and load programs remarkably faster than any disc drive (even hybrid). SDD cost are coming down faster, too. I recently disassembled a few 3.5" HDDs. They have wonderful machining and some pricey components (e.g., copper servos, neodymium magnets) that are not getting any cheaper.
Of course, today's 1TB SSD will cost $100 in three years. But that has always been true for storage.