In general, a lot of pre-laws and even people in law school have woefully unrealistic salary expectations. After they start looking for work, they have a rude awakening when they see what things are really like.
In my opinion, there are perhaps 10-15 law schools that are maybe worth taking out big loans for. Depending on the individual situation, it may not even be worth it for a particular person to take out those loans at one of those 10-15 schools. This is why I always tell people to consider their in-state school. Or obtain residency somewhere, even it means getting a job for a few years before going to law school.
Good luck with sports law. The field is very small and very competitive. I took a class with an adjunct prof who works on big player contracts, stadium deals, etc. He also brought in one of his colleagues as a guest speaker and they spoke about how they got into the field. Both of them had gone to top ten law schools, and worked as big firm lawyers and corp counsel for several years before settling into the work they do now.
I don't know anything about your connections, but I do know that most peoples' connections are not as good as they think. You may find yourself doing very different work than you intended for a lot less money.
I could live with that, as long as I have a shot at my goals. What I couldn't live is going to a school where finishing #1 in my class gives me a $50,000 job and finishing in the middle makes me jobless.