This thread is a good read on the current situation SSDs find themselves in WRT data retention:
TLDR: almost all consumer SSDs, even if periodically powered on, will let data degrade over time; the degradation mostly affects the read speed of the data and it isn’t until years later that’d you’d have to worry about the data actually being corrupted (this is assuming the SSD still has reasonable health of course).
As long as nothing goes wrong mechanically with HDDs, I’d expect them to retain data for multiple decades; I’d preclude EAMR HDDs from this statement until they prove their long term reliability alittle more however.