@barrons, only if you don’t do well enough in undergrad to get in to grad school. Lots of prestigious grad programs that get recruited out there. And opportunity is heavily dependent on field as well as geography. For instance, if you want to become a landman, some of the highly-regarded schools in that field are nowhere near any national top 100 list.
Likewise, UCincy isn’t in the top hundred, but it is one of the most highly-regarded schools in the design world (as well as a few other fields).