We had a very stressful time with DS and his sports scholarship.
I think it comes down to (with the benefit of hindsight) how much time you need to dedicate to your sport outside of school, whether you accept the scholarship or not.
In DSes case he was equally good at rugby and football, and played at district level at cricket, and a strong, although not top, athlete. His passion was football, and he was signed and playing for a premiership team, with the ultimate aim of becoming a pro footballer.
We chose his school partially because there was no Saturday school and would allow him to be free at the weekend to play football outside of school. It just wasn't that easy though. The school wanted him to be available not just for their football team, but all their other teams as well, with the insistance that the school always came before his football club. Of course the matches were in Saturday's as well as tournaments on Sunday's etc.
We were in and out of meetings with the headmaster, emails, letters
etc, they took the scholarship away then reinstated it. In the end we gave it back, it just wasn't worth the hassle. A stressful time we were trying to shield DS from. He just wanted to play football primarily for his club, and then the school, if he was free from club commitments to do so.
My advice to anyone now to anyone who's child is a good sportman and offered a scholarship is that it is great to get the kudos of having a scholarship and playing for the school teams, developing yourself in one or more sports through the exceptional coaches and teachers the schools usually employ, get the money off the school fees (it adds up) it makes more than good sense to take it up. If you are an elite, for want of a better word, sportsman forget it. The outside commitments v school is very difficult to manage. On top of all the school work as well!
I don't know if works better for other sports though. Cricket, and the county set up, might make it easier for example.
Sorry that was a long post, but I wanted to get the perspective across that it is not always the correct decision to take one up.
Good luck to your DS.