What's the deal with .tiff files?

Picasa (the program, not the website) supports TIFFs; it’ll automatically convert them to JPEG when you try to upload them.

You just have to configure Picasa to show them: Tools -> Options -> File Types -> .TIF, .TIFF

This. I’ve often had problems dealing with TIFF images that people sent me. They are too many variants.