This, basically.
They're aimed at the complete ignorants who go "Oh, pretty plants". Not the top 5 Elo. They introduce the champion and the skills and lately Phreak has been introducing a few more basic gameplay tips as well. That's about the extent of what you can expect. If you want in-depth, go look some pro play at tournaments.