Interesting article and video about Google releasing an app to let "non-programmers" make their own Android Apps...
Google App Inventor: Now Anyone Can Create an Android App
Google App Inventor: Now Anyone Can Create an Android App
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.

I signed up. I'm working on learning Java and I see it as just another tool in the toolbox.
...like soundboards my daughter can play with...

wow, awesome. Now I can make some apps for my phone (like soundboards my daughter can play with) even if I don't care about putting them on the market.
I used to use Klick N Play, Shoot'em Up Construction kit, RPG Maker 2000 back in the day to make some pretty cool (simple) games.
Looking foward to it
I guess it really depends on how many of these "home brew" apps make it to the market. If they just start showing up without any way to sort or separate them, it's going to be a mess.
yeah, it will be interesting to see how quickly the market grows, but at the same time it will be interesting to see how much CRAP makes it into the market to have to search through in order to get to a decent app.
To be clear, App Inventor isn't about to replace or even threaten the traditional developer model -- far from it. Apps built with Google's new tool will be less robust and advanced than what any professional developer could create; we're talking about two entirely different leagues of programs. In fact, despite what you may have read elsewhere, apps created with App Inventor won't even be published to the Android Market as of now.