I think his point is, and I don't entirely disagree, that you can "explore a bit" for a hell of a lot cheaper at a community college. Its $26 a unit to explore at community college here, it can be anywhere from $5000 a semester to $1000+ per unit to explore elsewhere.
There is more than just Ivy League and party schools. While I would say that if you are accepted at an Ivy League school and you can go, you should, I don't really think anyone from an Ivy League is any more special than anyone from a good state program such as Berekely, UCLA, University of Virginia, etc. or even many smaller private programs.
Ivies tend to have good graduate programs in most fields. I'd say it would be better to go there for an advanced degree than for a bachelors mostly because of the availability of lots and lots of research funding that many, even top state schools, can lack.
No, lots of courses do transfer. In fact, if you plan in right, the vast majority of your courses can transfer. I know more than a few people who have transfered into Berkeley, UCLA, UCI, etc. from the CC system here in California and have had no problems finishing in what portion they have remaining of four years of study (usually two years at CC and two at university, though I have friends who have done one year at CC and two at university, and 2.5 years at CC and 1.5 at university). Also, lots of community college students aren't at the low end of the academic spectrum, cost is a huge factor in why many students go to them. Why pay thousands for lower level general eds taught by graduate students when you can pay $26 a unit for lower level general eds taught by professors with experience and a graduate degree in their name?
I never attended community college as a degree seeker, I go to a private liberal arts college, but I do take extra courses at CC (to save money since I take more than the standard 12-18 units full time tuition pays for and over 18 units at my college is over $900 a unit) and I've had numerous friends go there. Its a good system; it can set you up with excellent college opportunities after you finish some GE's and it can save you a small fortune. Does it have problems? Obviously, but so do most state and private schools.