First off, if your DS were making his 1st communion from my school (Catholic) or Religious Ed. program, he'd be told to take the earring out or not attend. Plain and simple. Earrings are not allowed for boys (regardless of age) in my school or the religious ed program affiliated w/my school. Boys are told they must remove any earrings before they come to school or religious ed. Even our girls are allowed to wear only one piercing in each ear. If they have 2nd, 3rd or whatever number extra holes, they must take those earrings out. While necklaces, bracelets and rings are allowed, they must be religious (crosses, saint medals).
Second, if I were you, I'd check into your religious ed's policy of earrings for boys. I'm guessing your child doesn't attend Catholic/Religion based school b/c this would not be allowed in most religion based schools.
You asked for opinions and I'll tell you that I think earrings on little boys are obnoxious.
And, in all honesty, I hate how you said you sat him in the chair to make sure he wouldn't get out/change his mind (was it really HIS idea to begin with?) and that you made fun of him by comparing him to the baby who got their ears pierced. This sounds like something that a teenager would do to a kid to get them to do something ... not an adult!!!!
For the person who called the pierced ear look "Redneck" ... we'd call it "Trashy" or "Ghetto" or "Cheesy" in this area.
I have a 9 yo DS and if he wants his ear pierced, he can wait until he goes to college! It won't be happening under my roof!!!!