Correlated fluctuations in luminosity distance and the importance of peculiar motion in supernova surveys