For certain career paths it helps a lot.
It also depends on where you live. In the Northeast there is a very tangible class system based on where you went to school. This still exists on the West Coast but it's much less intense unless you are going for big-time VC money or working in law or finance.
However, I have yet to see anyone become a Supreme Court Justice who went to community college. I believe almost all of them went to Harvard or Yale...
To be fair, you cannot become an attorney just going to community college. You need a graduate degree. Graduate school admissions do not have the legacy admissions preference that undergrad does. While true that all current SC judges went to Harvard or Yale, they did not necessarily go for undergrad. For example, Clarence Thomas went to Conception Abbey Seminary for undergrad, which is a little-known school in Kansas.
Expecting that only top-tier colleges can train good lawyers is elitist nonsense, just more gate keeping by the upper class.
https://en.wikipedia.org/wiki/List_of_law_schools_attended_b...
Sadly, the jobs that are most dominated by nepotism and politics (law, government, academic professors of softer subjects) it really does help to go to Harvard or similar and have the brand name. Value-producing industries in the private sector are not exclusively merit-based, but it's much more likely you can go from the bottom to the top by starting a competitive business. And starting a business does not require going to Harvard.