My understanding is that these projects are a side-effect of how Google judges promotions. If you’ve “created a new product”, that puts you higher on the list to get promoted.

There are no incentives nor resources for maintaining those products. So you see a long list of “ideas” from Google that are abandoned immediately after someone got their promotion.