It is not fault of the ranking report but your judgement call

Top university  is for students who are motivated and top 10% kids in high school. College application is a two way selection process. US news report never said it is a guide for high school kids. So don't blame the ranking report, but blame your own judgement and choice.