Sometimes a cigar is just a cigar and a charitable act is a charitable act. If you want to invent a hidden agenda for this, then the most reasonable one would be Good PR.
I don't see anything wrong with collecting SSIDs that are being broadcasted onto public roads.
But to get back on topic- Google is doing a good thing here and should be commended for it.
If you don't want your SSID or Wifi public, disable SSID broadcast in your AP and turn on WPA2. The biggest threat to you isn't Google slurping up your SSID/Mac Address, it's some dude standing stationary outside your house capturing everything you do.
If you want SSID broadcast but don't want to be indexed, add "_nomap" to your SSID and Google will ignore it. But Skyhook, Apple, and others probably won't.
That's amazing.
Non-paywall article: http://techcrunch.com/2013/07/24/free-wifi-san-francisco-goo...