Froogle's been continually updated, even if it's not very good it appears to be as good as comparable products. And blog search is largely integrated now. (One wonders if it's worthwhile to maintain the distinction at all, now that Google's algorithm has a better 'understanding' of blog-style posts and links.)
Google Video and Notebook are good examples of projects that seem to linger and rot, but are in fact just having their energy devoted to their successors. Google Video development is being channeled into Youtube updates and Notebook into WAVE-based document creation.
And the only reason I didn't respond to your comment about FSJ's analysis is I agree with you 100% on that. Lyons' is without a doubt the most insightful and interesting commentary thus far.
I just think the 'Google is unfocused/fickle/etc' meme needs to be approached critically and put out to pasture if it's found wanting. (which i believe it is)
As for their social networking acquisitions vs WAVE, I'm completely ignorant on both (and expect to remain so, along with most of humanity).
But my main point isn't Google, but FSJ's tech coverage. Between Techcrunch & co hysteria and The Register's empty cynicism, I think FSJ's piece remains the best analysis of the Chrome OS announcement yet.