Not surprising. Larger, more comprehensive Universities will rank higher on the CWUR ranking because there will be more and more impactful publications and patents out of the larger Universities.
USNAWR ranking depends a lot on reputation, which, as stated above by one organization is a risky way of doing rankings.
For example, a student wishing to major in ceramic engineering would be wise to choose Alfred University in upstate New York over any Ivy, Stanford or Carnegie Mellon. Alfred University is world renowned in ceramic science and engineering, while the Ivies and other schools are not
Similar situation for football players and other athletes selecting a university. In one respect, it is admirable for all of the best players to want to play for storied, perennially ranked programs. But what is the reality? Do athletes get to choose their major? Do they have a life after football program? Will they see the field?
The "best" Universities ultimately is a subjective thing, depending on each student's needs and desires for what they want in a college education. Too many kids are chasing ivies and Stanford and Carnegie Mellon when they should be choosing the best place for them and their intended major, if they know it. @RU848789 may have something to say about this too?
ditto this post. My daughter is now graduating from the Wake Forest Physician Assistant program, ranked 7th in the nation. Their medical facilities are second to none.