It takes time to change rankings since they’re based on perception and those take a long time, probably more than two years. Also, the top-10 in finance on the usnews list is going to be tough to dislodge - you’re talking UM, Texas, NYU, Berkeley. If you’re off put by the 31 (and it’s ok to be so), then you’re better of as Publisher mentions to consider Texas, Michigan, IU, depending on grades and affordability of course.
CPAs tend to have less stress than IBankers, at least after tax season, if you want non-accounting, then probably corporate finance roles. Good luck!