All this is true, but we can get support for our research from colleagues at other institutions doing related work. We all are in a sense part of 2 departments, our physical department where we teach and our intellectual department of people, who are in departments all over the country or the world, who share our interests.
I teach a 3/3 at an all-undergraduate public university. What others have said above is true. The job can be fairly easy, if you are ok not doing research. That's the road many of my colleagues have chosen, and they can skate by producing almost nothing, even though research is technically expected. If you want to keep up an active research program-- like I do-- the workload can be very heavy.
The hardest thing to adapt to is how little my colleagues care about my research. When I get articles published, nobody notices. When I get grants, nobody cares. There's little celebration of anyone's research successes. I think this occurs because the more attention that gets drawn to my successes, the more they fear that they'll have to start producing. Or, at very least, they fear that admin will look at it and say "She produces X articles a year; why can't you?" So, I mostly do my research in isolation and without a lot of support or recognition.
I think it's easy for faculty members in my shoes to feel bitter because, deep-down, we feel like our productivity should earn us more respect, more money, or more influence in institutional/departmental decision-making. It took me a long time to figure out that it doesn't. It's a total non-factor. Nobody cares. Seniority matters more than productivity.
Last thing I'll say: Nobody cares where you went to school. Ranking and pedigree are total non-factors for anything. They might matter within the discipline (i.e., at ASA where people look past you) but within the university, nobody cares if you did your PhD at Harvard or at Iowa State. The Harvard parchment doesn't impress anyone.
This is almost my exact experience. I have a lot of colleagues who barely produce, and�because of that�aren�t supportive or happy for me at all when I get publications. It�s been really isolating, honestly.