I was afraid of heights as well when I started climbing – to the point where I was scared of looking out of windows above a certain height. It's still something I have to deal with (especially when I go lead climbing), but it's gotten better the more I've climbed! It's usually pretty affordable to do an intro course or a day pass and try it out just once, that'll let you know whether you enjoy it enough to push through the fear.