First of all,
for what you went through.
I agree and disagree.
Childhood sexual abuse can affect people differently, but generally speaking, it's something that's best dealt with by someone who has had specific training and specialises in it. It sounds like your counsellor wasn't. If they were, then they weren't experienced enough to recognise that it wasn't working and look at alternatives. So it sounds like s/he failed you in that instance - also because they didn't refer you to someone else who could be more help.
I agree that it's not a magic bullet though. Especially trauma work. It can be exceptionally hard, but the pay off is your life becomes better. It's not fair though that someone/people get to hurt you and then you have to work hard to undo the impact of their actions. Throwing it out to people as a quick fix is disingenuous.
It's worth knowing that (I'm assuming you're in the U.K.?) there are a) different types of therapy and b) different types of therapist and c) (in the U.K.) anybody can call themselves a counsellor. What works, or doesn't also isn't as exact a science as we'd like, especially for childhood traumas, because everybody is different, has different histories and life circumstances. And wants different things ("feeling better" for one person might be no more nightmares, whilst for another it could be no more flashbacks, panic attacks and dissociation). However, in general, counsellors are ethical people and rarely doing something they don't think works.
So this therapist, doing this therapy, with you right now certainly didn't achieve much for you. That doesn't mean no therapy model will. There are technically some people for whom no model will work.
The other thing people don't realise is that when you see a therapist initially (well, any time, but from the first session) you can ask them about their qualifications, you can ask about whether they've had professional experience in the area you're looking for help in. You get to check them out.
Therapy when it's done well is life changing. I say that as someone who has a lot and still does due to childhood abuse. But for me, it's been long and slow, partly because of my circumstances.
Lastly, because this is long! If you're ever interested in trying again, these terms might help you find out more info and/or a better counsellor for you.
EMDR
trauma-focussed CBT.
Complex trauma (a trauma that happened more than once and/or the threat continued over an extended period of time). Developmental trauma happened during childhood.
Complex-PTSD