Sorry, haven't read all answers so I hope this isn't a repeat, but:
See if you can get him an older scout (not an adult leader, a responsible and interesting and active teenager) as a mentor and let that boy take him to THEIR meetings and activities and talk to him about what lies ahead if your son stays in Scouting. Find an older troop that is doing some very cool stuff, or a boy who is doing an interesting and engaging Eagle Scout project. Let your son see for himself that Scouting is what HE makes of it, not what his troop makes of it; it's about the activities, not the meetings.
And yes, do tell his scoutmaster or troop leader or whatever it's called -- tell that adult that your son is bored and needs more responsibility and activities or Scouting will lose him! Any GOOD leader will jump to it and try to keep your son on board. Because if he's bored, other boys will be too.
It's very telling that your son is a natural leader but wants out of Boy Scouts, which is exactly where natural leaders belong. There are surely other parts of scouting that will keep him on board. I don't know about Boy Scouts but in Girl Scouting it is not against any rules to change troops if your current troop is just not working for your child!
I note you mention camping. I know many Boy Scout troops camp and camp and camp but is it possible he just really needs other kinds of activity? I find camping boring as well, after a while. If the troop is about nothing but camping plus disorganized meetings that have no specific activities -- I would find another troop with more organization and more imagination about activities.
I hope he finds a place for himself in Scouting (I am a GS leader and very pro-scouting for both girls and boys) but if he cannot, get him involved in some form of volunteering -- library page, something at your place of worship if you are so inclined, school programs like Lego Robotics or Odyssey of the Mind or Science Olympiad etc. etc. -- something with a team aspect as well as individual excellence. Oh, and ban the word "bored" from your home. We don't allow it. If something a child is doing is "boring" the question is: What can you as the participant do to get more out of it, rather than waiting to be "un-bored" by someone else's efforts?