IMO, we have all been down this road with our players. The hardest thing to do is let your son make his choice which may differ from you. I have always had to remind myself that I have played and this is his turn and choice. We always sat down and talked before he started playing any sport and talked out the good and bad, what he might miss, both from the sport and social life. The only rule was if he started, he could not quit, whether he was the best on the team or the worst, but had to stay with his commitment.
Your son is young enough that if he wants a break he may soon realize that it is something he misses and go right back to playing.