Fusion drives aren't going anywhere, and neither are HDDs.
As an example, a client has approximately 200 DVDs that are about 10 years old and the DVDs are beginning to fail. Their options are SSDs, HDDs, or more DVDs. SSDs are out of the question because of the shear cost. The customer wants to avoid more DVDs because time has proven them to be unreliable. A Fusion drive or hybrid drive could be options, but the speed isn't that important. The solution has been to transfer the video media to HDD and then use a Mac Mini as essentially a video server.
As an interesting side note, DVD quality really does (or did) matter. All of the DVDs that were Philips brand are now failing. I'd guess about a 90% failure rate. The Memorex DVDs remain intact and useable, with probably a 10% failure rate. There were some others used but I'm not sure what the brand is, and they're failing as well like the Philips. At one time there was a brand of ultra high reliability DVDs made by someone, I think it was a subsidiary of Panasonic, but the name fails me right now. I looked into them and they've now stopped production. There is also another super-high reliability DVD maker out there whose name once again fails me but the cost is relatively high, but it's a fairly new product.
As I explained to the customer, the real problem with DVDs, even if they're of true archive quality is the optical nature of the product itself. A standard hard drive uses electromagnet signals to convey information in an essentially sealed chamber. DVDs get exposed to the environment including dust and the side effects of human handling, which can interfere, distort, or even block the laser from reading the signal properly. Although an archive quality DVD may last a long time, the fact is that if the light path between the media surface and the laser itself is obstructed by dust, for example, that section of the DVD simply won't get read. For an archival quality DVD, cleaning the DVD or even just blowing dust off of it may clear the problem, but it will always continue to be a problem. SSDs and HDDs will not have these problems.
The lifespan of an SSD for long term storage still seems to be an unknown.