Both SSDs and HDDs have their advantages, and both can fail, but their weaknesses are very different. Here's what really determines which one lasts longer.