Correlation measures whether Y=mX+c holds with small error. I sometimes think that many people unknowingly assume that all dependencies are somehow straight-line ones. This is distinct however from "linear approximations" in physics, which can at least be justified sometimes.
I also suspect that correlations of 0.5 or lower are often just statistical noise.