Sure there are fairy tales at D1. A kid works his tail off and eventually earns playing time - to me, that is the best possible story.
My son's recruiting class had 9 players. Three were there for senior day. One was drafted as a junior and signed (Marcus Stroman.) So the attrition was very high. (Some of that, perhaps most, was due to a literally mentally unwell coach who was fired after my son's junior year.)