I'm afraid of horses too. But I will ride one...weird?
Just don't ask me to pet its face or brush/saddle it or stand near it.
Once I'm on a horse I'm fine. And will ride all day. I'm okay petting them while on them too. And they are beautiful animals.
I guess Im afraid of their legs and teeth. Was thrown as a kid but still can ride...