When you sand with a much higher grit, you're closing the pores in the wood (which is why it feels smoother) and the stain/water repellent won't penetrate as deeply and won't last very long, especially with foot traffic. I have a cedar deck and stop at 80 when I refinish about every 3 to 4 years.