Think of the atmosphere as if it were an ocean. You might not think water has weight if you were diving underwater, but obviously when you fill up your cup with water you feel its weight increase. The atmosphere is really just a gaseous ocean on top of the surface. In extension, if you were to light a candle on the edge of a building taller than the Earth's atmosphere, you would see the smoke fall towards the Earth.