The practical application of sulfur (S) cathodes in lithium-sulfur (Li-S) batteries is hindered by the shuttling of soluble lithium polysulfides (LiPSs) and sluggish sulfur redox kinetics. Addressing these challenges requires advanced catalytic host materials capable of trapping LiPSs and accelerating Li-S redox reactions. However, single-site catalysts struggle to effectively mediate the complex multi-step and multi-phase sulfur conversion processes. In this study, we present a novel dual-site catalyst, featuring nickel single atoms anchored to nitrogen sites (Ni-N4) within a carbon nitride (NC) matrix and molybdenum carbide (MoC) nanoclusters. Experimental and theoretical analyses reveal that MoC sites efficiently catalyze the reduction of long-chain LiPSs, while Ni-N4 sites drive the reduction of short-chain LiPSs. When incorporated as a coating on the cathode side of a commercial polypropylene (PP) separator, the Ni-MoC-NC catalyst enhances sulfur utilization, suppresses LiPSs shuttling, and facilitates a uniform Li+-ion distribution. Thereby, Li-S batteries demonstrate outstanding performance, including an initial capacity of 1624 mAh g⁻¹ at 0.2C and 1142 mAh g⁻¹ at 1C. At a sulfur loading of 8.3 mg cm⁻² and an electrolyte/sulfur ratio of 6 µL mg⁻¹, the system achieves an initial areal capacity of 9.57 mAh cm⁻² at 0.1C, showcasing significant promise for practical applications.