The Niche party rankings are useful because they include pretty much every school, unlike the Top 20 rankings we often see. That way I can start with the football rankings (here, the most recent AP rankings) and compare that to how well the schools ranked in, um, partyness. You'll see the table below. I can tell you there next to no correlation here (r = -.01). The top five ranked football schools had an average party ranking of 99.4, in large part hurt by Mississippi State's dismal 255 ranking and, to a lesser degree, Auburn's surprising 108 ranking. No doubt also scramming the data is Baylor, ranked 10th in football and, wow, 800th in partyness. Also, having highly ranked party schools like Wisconsin and West Virginia at the bottom of the Top 25 football rankings helps make the correlation next to nothing.
A few nerd points. The mean (average) party school ranking among the Top 25 football schools is 137.2, the median is 70. Why the difference? Because the mean is sensitive to outliers (I'm looking at you, Mississippi State, Baylor, Utah), hence it drags the number higher in this case. So we have a median of 70, meaning half the schools are above 70, half below. Well, except TCU, which sits right at the median. Four of the Top 10 schools are above the median, meaning that while they excel at football, their party school skills -- as measured by Niche's iffy methodology -- leaves something to be desired.
The worst stretch is from #20 to #24 (Clemson through Marshall). Five teams in a row above the party median.