Yes, that's a good example of why not to use S3 as a simple backup destination. However software like Jungle Disk on running on top of S3 adds versioning and deleted file retention to make it act like a real backup system.

Having a local backup is great too, but that won't protect you from fire, flood, or theft in many cases.