At least as of 10 years ago, that was pretty true to real life. Maybe not quite the disdain for state universities, depending on your state, (and University of X was always preferable to X State University), but certainly community college was scoffed at, and the goal was to go places.
This is true even if (as many TV students do) you attend high school in California, where two of the state schools are among the top schools in the country. It REALLY bothered me in Veronica Mars
they had a bunch of episodes about how if Veronica didn't get the Kane Scholarship (the only scholarship in the whole wide world, apparently) she would never go to Stanford and would be stuck in Neptune forever. Never mind she had the second highest GPA in her class, worked two jobs, was being raised by a single parent (meaning she would be eligible for all sorts of loans and grants) and, oh yeah, caught a world-famous murderer in a high-profile case that made the cover of People
. Even if she couldn't swing Stanford with 100% of her tuition and living expenses covered, she could have definitely done it for Berkeley.
Because all the good universities are private, and all the bad ones are state schools. There's no such thing as, say, UVA or University of Illinois or Texas. And there's no such thing as expensive liberal arts colleges no one's ever heard of.
TV has taught me there's only ONE college, or ONE scholarship, and if you don't get it you're going to spend the rest of your life in your small town as a gas station attendant/diner waitress. And you deserve said college/scholarship, and if you don't get it it's not because they're extremely competitive, but because evil rich people in your town want to sabotage you. There also aren't government loans or grants. This is why so many small town girls with big dreams have to put themselves through school by stripping.