In some subjects, isn’t tenure-track faculty hiring so competitive that the illustriousness of tenure-track faculty is high even going a lot further down the rankings?
Of course, lower-resourced (probably more commonly lower ranked) colleges may rely more on adjuncts for the less desirable (to the student) reasons*, although even the adjuncts may be pretty high on the illustriousness level.
But then each college’s department may have different ideas of what content to teach and how to teach it, regardless of how illustrious the faculty are.
*As in providing flexible capacity management in lower level courses, as opposed to the more desirable reason to get an outside-of-academia perspective for a specialty elective.