I think Google used to have a corporate culture which encouraged this and from what this writer says (so it's just an anecdote, not data) they might be losing that culture. Doesn't mean Google will fail but having that kind of culture is an ongoing job and it's non-trivial. Seems like they might be letting bureaucracy creep into the organization.
But the constraints of keeping a billion people's needs in the back of your mind are real, and they impose limitations on what you consider worthwhile. It just wouldn't make sense for Google to study Chicago Public School utilization data, for instance - it's waaaaay too small a focus - but I find it deeply fun and meaningful, and not having to make something bulletproof for 1/6 the planet to potentially use just means it gets out the door quicker.
But your point about working on fun projects that are too small to matter to the world at large is very well taken.