Emerging contaminants in water sources present serious environmental and health risks, creating an urgent need for efficient and reliable treatment strategies. Photocatalytic advanced oxidation processes (AOPs) provide rapid reaction rates and strong oxidation capabilities, however, comprehensive evaluations of wastewater treatment, including degradation pathways, toxicity assessments and mechanistic insights, remain underexplored in the literature. This study presents novel S-scheme Mn0.5Cd0.5S/In2S3 (MCS/IS) photocatalysts for efficient degradation of antibiotic pollutants, with a particular focus on tetracycline hydrochloride (TCH). The optimized MCS/IS photocatalyst demonstrates exceptional degradation efficiency and robust resistance to inorganic anions. Additionally, a continuous-flow wastewater treatment system, using an MCS/IS membrane, demonstrates outstanding stability in TCH photodegradation. Utilizing response surface methodology and Fukui function analysis, the effects of various parameters on photocatalytic degradation rates, along with the associated pathways and intermediate products, have been thoroughly investigated. Toxicity assessments confirm the environmental safety of the treated effluents. Mechanistic studies show that the S-scheme heterojunction in the MCS/IS photocatalyst improves electron-hole separation, thereby enhancing photocatalytic performance. It is expected that this study will serve as a model for advancing the removal of emerging contaminants, further enhancing photocatalytic AOPs as sustainable water purification technologies.