Although the development of superhydrophobic coatings is rapidly maturing, issues related to their low mechanical durability persist. In this context, the effect of substrate roughness on the service life of superhydrophobic coatings was studied. In this study, superhydrophobic coatings were fabricated on sandpapers of different roughness and reciprocating wear tests were conducted. The wear-resistance number of the superhydrophobic coating, defined as the maximum number of friction cycles after which the superhydrophobic surface started to lose its superhydrophobicity, increased from 50 to 24,000 with an increase in the substrate roughness from 2000 CW to 240 CW (CW is defined as the number of particles arranged in an inch), while it decreased from 24,000 to 17,000 with a further increase in the substrate roughness from 240 CW to 60 CW. Observations of the surface structure and wear analyses indicated that the superhydrophobic material infiltrated the spaces between the sand grains, and the rough peaks could consequently protect the superhydrophobic material during the wear tests. However, this protection weakens when the substrate roughness increases or decreases beyond certain values. Furthermore, these phenomena and results were also verified by applying the superhydrophobic coatings to different types of common substrates.