There are three things athletes can do in college: social, sport, and academics. Doing two out of three well is about all a parent can expect.
S and D attend(Ed) the same very selective academic college (D1). There are no athletic scholarships in the conference (though FA is fabulous). Both were very powerful HS students with matching test scores. Both knew how to study; S was motivated to keep parents off his back while D was totally self-motivated. S was a baseball recruit; D does a sport which is classified as an emerging sport.
In D's sport, the conference has some schools which are NCAA in the sport while the other half of the conference treats it as a club sport. There is, however, a conference championship in which all teams compete as equals. S achieved conference recognition in his last year; D was the runner up in her first year and conference champion in her second.
Baseball was essentially a full time job (ranging from 20-30 hours in the off season to 60 in season). The other sport required about 10-15 hours per week (including conditioning).
Both matriculated thinking Chemical Engineering. S's Chem Eng ended before the first day of class; he was warned off by older members of his team. D is a Chem Eng (who will never be a practicing engineer). D has a 3.5+ and essentially lives in the library; I'd say she works on academics eight hours a day, seven days a week. She can do that as well as her sport; no way S could have done that.
S's class had eight players. Four years later seven graduated (the other signed after his junior year and graduated the following year). When those eight matriculated, several dreamt of medical school, a couple were engineers, two were looking at history and one Economics. At the end, two were history majors, one a science major, one poli sci, and the rest Econ majors. Three are playing proball, one went to medical school (the true walk on). All the rest (including the two who went pro after senior year) had well paying extremely selective jobs lined up before the end of their first semester senior year. Two graduated with academic honors; the rest graduated - the job market did not distinguish those with honors from those without.
Did the baseball time commitment effect GPA; you bet it did. Did baseball effect the choice of majors; you bet it did. Did baseball adversely effect their career paths? While too early to make any definitive pronouncement, all the players are in a position where they are the masters of their respective futures.
S graduated dead middle of his class with an Econ major. He had multiple job offers of which he was satisfied. Having played helped his ability to figure out what type of job he wanted (e.g., team oriented) and really helped during interviews, but the time commitment meant he spent less time in his studies then his sister. At one point (sophomore year) we dropped the hammer and told him if he produced a single semester below 3.0 he was back home or out of baseball. He kept his GPA over the minimum - probably by manipulating his electives towards the easy part of the spectrum. He played baseball the first and second summers, but when it became apparent to him that his career was not developing along the pro trajectory, he found a summer job in the third summer. It juiced his resume mightily.
As I said in the first paragraph, academics, sport, and social, pick two out of three. So, S had a robust social life - it began with a core of baseball players, rapidly expanded to other athletes, and then expanded to include the most diverse group of people imaginable (he came from a fairly insulated background). His school does not house athletes together, but you can choose roommates in the second year. He never roomed with athletes, but most of his teammates did. He joined what most consider to be a social club analogous to a frat and loved it.
From a parent's perspective, baseball in college is what made him what he is today. Yes, it wasn't the first choice major (as is true with most college kids); yes, he didn't and couldn't study as much as his sister and hence didn't quite make the same grades (in an easier major), yes, he gave up a lot to play; but the pluses far, far outweighed any minuses.