Larger storage means each cell gets written to, less which would make them last longer as what kills them is write cycles.The SSD has its fans even though the SSD usually costs more, requires a USB cable, takes up more space in the glove box and uses more power than the SD card. If you search the TMC forums there are threads where SSD that previously worked without issue suddenly stopped working after the Tesla USB firmware was updated.
With later software the Tesla Model Y has become more sensitive to the maximum power being drawn from the USB data port. This might trigger some errors. It is worth checking the specs because not all SSD have the same power requirements, some use less. Some SSD may be better able to tolerate the temperature extremes of the inside of an automobile.
The primary advantage of an SSD is the additional storage. The additional storage is typically used for storing audio files.
From what i have read, the controllers in SSD's are also better at "wear levelling" than the rather simple ones inside of a SD card which again would equate to longer life, atleast on paper.