As my regular confessor tells me frequently “Be not afraid!”. I think part of the fear stems from the work of the enemy… Why? If you’re forgiven of your sins, he cannot hold them against you. When one is in a state of mortal sin, they are in a state of being separated from the Body of Christ, and therefore usually more suceptible to straying further and further from that Body and from the graces that flow from that Body and possibly into the hands of the enemy. In confession, it is like saying “To hell with you, Satan,”.
I see confession like this: when I was a little kid and was bullied on the playground (and usually was just as rotten to the bully (or Satan) in response), I would run to the teacher, and tattle on that person. I didn’t like telling on that person to the teacher because I knew the bad behavior I had participated in would come to light, but that was also needed so I could learn how to do better the next time (like telling the teacher before I started throwing rocks at the other person…

) The same way, in the confessional, I am tattling on Satan, and in addition, I’m tattling on myself… the priest gives me advise on how to better avoid that situation again, and through the power and grace from the Sacrament, I am better equiped to deal with it in the future.
I usually am a nervious wreck before confession, and I go at least every other week. I know the priest isn’t going to judge me, and only has my spiritual health and best interests at heart, and also that afterwards, I will come out feeling much better and “squeeky clean”, but the fear is still there. I pray to St. Michael for his intercession before hand, and a prayer of gratitude afterwards before I complete my assigned penance.
Let us know when your first confession is, so we can be praying for you!
Ericka