I think it comes down to either you want to ride or you don't. Like every other horse rider on this forum, I have had a couple of spills, the worst one involved mounting a horse and was the hardest tumble I have ever taken. It hurt and was horrible but my passion for horses and horse riding out weighed the experience. However it was hard to get over and to this day (14 years later) I still get a moment of fear when I put my foot on the stirrup of a strange horse.
You are going to have to make a conscious decision as to how you feel about horse riding, either it is something that is important to you or it isn't. Only you can know. Also bad stuff happens randomly throughout our lives, part of life is learning coping skills and learning to pick ourselves up and keep doing what we love. Please also remember there are a lot of horses out there and you are allowed to look for something that you find more trust worthy.
Hey, I have suffered several terrible falls off my horse, the first two seriously injuring me, and the last one psychologically.
I was scared to get back on my horse, I tried to and I just sat there, my horse lifted his head to check out something in the distance and I had a panic attack, I was crying and hyperventilating before I walked around the arena one full time, I had to get off.
But I couldn't give up on my horse, I would force myself on, if only to stay in a small circle in the indoor ring where I was comfortable, but I would get on. Now, about a month later I've regained most, not all, but most of my confidence on my horse. I say give it time, what really urged me to get back on was missing riding.