I think you are right. Attrition rate seems to have gone down since I looked at the batch of schools around 2010.I think that you might be a little pessimistic about the power 5 conference schools Zoro. My players team only loses one or two players a year and it is playing time related 99% of the time. They have a 7 member senior class and from our interactions with the coaching staff they are clear to ALL of their recruits where they fit into the picture even the recruited walkons. One common thread among all of the recruits in her class is great grades and a rigorous course of study. Her incoming recruiting class has over a 3.9 average with every player taking an AP curriculum (other than the foreign players) and there is only one player player committed in any class that I wouldn't consider an exceptional student and soccer will get her in.
Glad to see you made it to the new forum you are very informative.
I don't know what the power 5 conferences are. I just always looked at the schools that were top 100 is soccer (top 30%) and top 100 academically (top 4%) and that also had the major my DD wanted. That tends to end up being about 5-10 schools then you narrow from there.
That 3.9 average is a number that means more in the context of the HS they came from. DD's school a 4.75 was possible over 4 years if you did not play soccer. It was (I think) 4.5 if you did. Then there are how many years it is averaged over. The whole thing on GPA is not very well defined. Which is why many (Ivy's are behind) schools like Stanford, ND use only a 4.0 scale, and they still vary on how many years they average. The Common Data Set top grade tier is >3.75/4.00.
Some schools give 6.0s and some give 5.0 for some PE classes (San Clemente HS for IB Dance).