Should you be afraid of heights?
Yes, initially you should be. Meaning your brain is doing it’s job. To protect you from real or perceived danger. Our reptilian or cave-man brain protected us from danger, danger of the unknown, wild animals, foods, etc.
But, in today’s physical reality, we don’t need as much protection, but try telling that to your ancient cave-man brain.
So my answer would be yes, you should be afraid of heights, but then look to the current reality to determine if you should remain afraid of that specific scenario and height.