The sad truth seems to be that Dropbox, iCloud and other cloud services are not safe enough for confidential or sensitive information.
Regardless whether or not Dropbox was hacked this time, they have been compromised in the past and most likely will be in the future.
In addition to security issues, there have been data loss and integrity issues, so cloud services are not safe for back ups either.
Here we're talking about average people's passwords leaked to the general public. Your files could be accessible by anyone. Or irrecoverably lost due to a bug. This has obvious consequences to the average person.
Well, I don't expect the average to understand the issue nor be able (read: want) to do anything about it (ie. encrypt before handing over their data to untrusted third parties).
Quite frankly, Jennifer Lawrence's nude photographs had more influence on the average person's thoughts about computer security than Snowden's revelations. As sad as it is.