I am 50+ Catholic. When I was a child, we were confirmed in 5th or 6th grade. Since then it has been moved to 11th grade. (Altoona PA).
I can feel your pain, my kids are grown, but they too transferred to public school and had to go to ccd program. It was a chore to get them to go especially when they scheduled them at 9:00 in the morning!
There are pros and cons. Confirmation is sacrament where you choose to continue a life in Christ as an ADULT. 5th and 6th graders are not adults, although some are very intelligent and somewhat mature, it is still not an age to make "adult" decisions. They still need some more answers, guidance. from religious education and parents. But is 11th grade the right grade, is that waiting too long....but if we confirm at 6th grade, is that 6th grader making a true adult decision.
But I think they do, at this age, need something similar to Confirmation--a proclamation perhaps of their desire to further their education until it is appropriate age for Confirmation.
I wouldn't want Confirmation to be given just as a reward for attendance. I'd like to see it as a real genuine decision these kids make.
Here is the conumdrum as you said, the kids in older grades do get bored in CCD classes when they only involve lectures, workbooks, lessons. I don't think that workbook lessons should be requirement. I think that at 6th grade, they should be tested -given exam-- to be sure they understand the basic concepts of Catholicism. If they pass, they then enter a period where they go into "community" phase--taking your beliefs into the real world. The boring lectures/lessons don't have to go away completely, but the big focus now should be to show them how to put our faith to action by providing them opportunities to volunteer, perform community service, do group projects with their peers. The time in the classroom should be used to meet as a group and contribute their ideas as to how they want to achieve it.
They are at the beginning of their teen years--a very rough time in life, where decision making is important. This is where the CCD program needs to provide them with books, literature, lessons, activities that help them make the right choices by using the gifts of the Holy Spirit and the friendships formed will be reinforcements. They are too young to figure this out on their own.
the CCD programs need help. They need resources, ideas for community service, group teen projects. They need the parents to help. Parents should volunteer to help in the CCD programs. Parents can provide so much input on what their children are interested in, marrying their interests with activities / community service projects. for example, if someone wants to be a doctor, they can become a candy striper in hospital, etc......
Parents should not leave the religious education up to the CCD program. I am not just talking about the facts, I am talking about the basic fundamentals of our religion, which to me is to be kind, to love one another, and treat people with respect and dignity as Jesus does.
One counterpoint I do want to make is, that too many times these days, we are letting the kids get away with NOT doing what they should do. They say "I don't like it. It's boring." and we buy into it all the time and say "ok, you don't have to go", that is not helping them either. They need to know there are certain things they have to do, whether they like it or have "fun" all the time in it. This teaches them responsibility. We don't always like going to work sometimes--it's boring and don't want to go, but we have to if we want to provide security for our children... and with this kind of decision and the importance, it should not be taken lightly.
Perhaps get involved. Offer some help or ideas. Start a Youth Group for the Teens so they can gather and do the fun things in a Christian atmosphere. It may help them get thru the "boring" lectures/lessons during regular CCD class