Some just fail hard and that ranges from bricking to loss of filesysten intregity.
Others stop allowing writes.
Still others will slow down, or lose capacity.
I have had two die on me after a few years of work involving tons of writes. One cheap SSD just bricked. Gone.
The Samsung I had started doing weird things with capacity.
Personally, I just cycle them when I see a deal out there.
Old ones do need to be powered up, from time to time just like USB thumb drives do, or the contents can be lost.