It means fear of big or giant things, larger than under normal conditions. It is one of the least recurrent phobias and does not refer to objects that are naturally large, such as an airplane, a building or a whale.
MEGALOPHOBIA terrorizes things exaggeratedly large compared to their normal size. There is fear of what is usually large, such as a skyscraper, an ocean liner or an airliner.