There are thousands of internal projects that are never cancelled and are very innovative. Serving queries at Google scale in Google times involves massive amounts of custom hardware, custom infrastructure, reliability engineering and many other things.

Many projects are cancelled, and I hate that, but that isn't really what life is like on the inside.