A novel photocatalytic nanomaterial, Ho2YSbO7, was successfully synthesized for the first time using the solvothermal synthesis technique. In addition, a Ho2YSbO7/Bi2MoO6 heterojunction photocatalyst (HBHP) was prepared via the hydrothermal fabrication technique. Extensive characterizations of the synthesized samples were conducted using various instruments, such as an X-ray diffractometer, a Fourier transform infrared spectrometer, a Raman spectrometer, a UV-visible spectrophotometer, an X-ray photoelectron spectrometer, and a transmission electron microscope, as well as X-ray energy dispersive spectroscopy, photoluminescence spectroscopy, a photocurrent test, electrochemical impedance spectroscopy, ultraviolet photoelectron spectroscopy, and electron paramagnetic resonance. The photocatalytic activity of the HBHP was evaluated for the degradation of diuron (DRN) and the mineralization of total organic carbon (TOC) under visible light exposure for 152 min. Remarkable removal efficiencies were achieved, with 99.78% for DRN and 97.19% for TOC. Comparative analysis demonstrated that the HBHP exhibited markedly higher removal efficiencies for DRN compared to Ho2YSbO7, Bi2MoO6, or N-doped TiO2 photocatalyst, with removal efficiencies 1.13 times, 1.21 times, or 2.95 times higher, respectively. Similarly, the HBHP demonstrated significantly higher removal efficiencies for TOC compared to Ho2YSbO7, Bi2MoO6, or N-doped TiO2 photocatalyst, with removal efficiencies 1.17 times, 1.25 times, or 3.39 times higher, respectively. Furthermore, the HBHP demonstrated excellent stability and reusability. The mechanisms which could enhance the photocatalytic activity remarkably and the involvement of the major active species were comprehensively discussed, with superoxide radicals identified as the primary active species, followed by hydroxyl radicals and holes. The results of this study contribute to the advancement of efficient heterostructural materials and offer valuable insights into the development of sustainable remediation strategies for addressing DRN contamination.