Low friction is highly desired for the durable superhydrophobic materials. However, achieving long-lasting lubrication with superhydrophobic coatings remains challenging due to their inherently mechanical weakness at present. Herein, the superhydrophobic epoxy composite coatings featuring spherical particle stacking microstructure were fabricated via aerosol-assisted chemical vapor deposition (AACVD). Through strategic incorporation of polydimethylsiloxane and coupling agent KH791, we enhanced superhydrophobicity (WCA >150°, WRA <10°) and self-cleaning functionality of the epoxy resin coatings. Crucially, despite lacking dense microstructure and exhibiting low hardness, these organosilicon-modified coatings demonstrated exceptional tribological performance, achieving simultaneously low friction coefficients (＜0.03) and long service life under dry friction. Mechanistic studies reveal this performance originates from: 1) Formation of durable PDMS transfer films on counterfaces; 2) Activated rolling of spherical particles at sliding interfaces. Synergistically, these phenomena enable macroscale friction reduction and wear protection of superhydrophobic surfaces.