I’ll try to answer your questions:
don’t see a column that says pages, only query.
These are tabs, not columns. First, click Search Queries (in the left-hand panel). Just below the heading Search Queries, you’ll see two tabs: Top Queries and Top Pages.
What does “avg position” mean? I mean I understand what it means, but if it says 6.0, does that mean I’m 6 down from the #1 spot?
Yes. 1.0 would mean the very top. 2.0 is one position down from that, and so on. The “average” means the average over all Google properties and countries (subject to any filters you have specified), and over the time period being reported.
Why do only 2 of my long tails have a CTR number under that column?
I don’t see anything that is telling me if I’m going up or down.
You need to click the “With change” button (between the graph and the table of figures). As well as actual numbers, you’ll see the positive changes in green and negative changes in red, so a quick glance will tell you if your pages are mainly moving up or down.
What’s the name of the 2nd tab that allows me to drill down?
Not sure what you mean by that. In general, you can drill down by clicking a specific query (on the Top Queries) page. That will show you the number of time the query has been in the top five, the second five, on the second page, and so on. Clicking on the page URL in the Top Pages section will show you an analysis of the queries for that page. This is particularly valuable, as it will show the queries that caused the page to rank well in the search results, but not well enough to generate many clicks - in other words, the near misses.
There’s a lot more to GWM tools than the features mentioned here. I’d encourage you to explore, and to use the Help link (top-right corner) to learn more.