Even though flash memory is erase-cycle life limited, meaning it has a finite life, I'd still recommend it for any application that requires frequent mass storage access. When flash memory started to be deployed in common use (2007 or so, with the introduction of the iPhone) there were concerns about their finite life. Those concerns appear to have been unfounded. Also, remember most iPhones and iPads have very little RAM, meaning they rely upon virtual memory even for modest tasks. Given that well over a billion iPhones have been sold, plus billions of all its imitators, whatever that erase cycle limit equates to in "n" years is large.
Magnetic media is not so write/erase cycle limited, but their in-service life is finite for other reasons. Given equivalent applications there is no justification for believing a traditional rotating hard disk drive would last any longer than flash memory. A hard disk's additional failure modes imply they will never be as reliable or last as long as an equivalent SSD.
Fusion drives are a cost-sensitive compromise, whose life will be limited by the component that fails first. It's not a bad compromise, but completely eliminating the hard disk drive is preferable. They are the vacuum tubes of modern storage technology.