Coastal water bodies face significant contamination risks stemming from various factors, such as growing populations, rapid urban development, dam construction, heightened industrial operations (notably in ports), and increasing tourism activities. The release of untreated sewage from municipalities, industrial discharges, and various recreational and commercial activities along the coast significantly deteriorates water quality and presents a serious risk to marine ecosystems, food chains, and human health. Hence, continual monitoring of coastal water quality is essential for the ecological sustainability of marine and aquatic ecosystems. This study examines the spatiotemporal variability of optical characteristics within the Sundarbans estuary system, a transboundary ecosystem shared by India and Bangladesh. The study employs Sentinel-3 OLCI satellite data alongside in-situ measurements of critical water quality parameters, including chlorophyll-a (Chl-a), total suspended matter (TSM), and chromophoric dissolved organic matter (CDOM), collected from 100 sampling sites across the Sundarbans estuarine system during the pre-monsoon, monsoon, and post-monsoon periods of 2021 and 2022.This study employs the sophisticated C2RCC model, a machine learning-based neural network-driven approach recognized for its robustness and precision. It examines the various bio-optical properties in tropical estuarine environments. The C2RCC model addresses this challenge directly. This advanced processor, powered by neural network technology, effectively interprets the complex optical signals found in Case-2 waters, offering essential insights into their quality. The findings indicate the highest TSM levels during the pre-monsoon seasons of both years. Additionally, the estimated Chl-a concentrations indicated a rise during the monsoon season (0.03-4 mg m3), whereas the intensified pre-monsoon CDOM levels showed consistency across both years. The strong positive correlation observed between in-situ and satellite data, with an average R2 value ranging from 0.90 to 0.99, underscores the reliability of the high-resolution remote sensing approach. The study illustrates the efficacy of OLCI data in observing near-shore and coastal ecosystems, clearly exceeding conventional methods for evaluating Chl-a, TSM, and CDOM. This study underscores the potential of high spatial and spectral resolution of Sentinel-3 Ocean color data for effective monitoring and management of the complex estuarine ecosystem of the Sundarbans. The findings of this study provide important insights to inform the development of sustainable coastal water resource management strategies. Furthermore, the findings will be crucial in achieving Sustainable Development Goal 14, which focuses on life below water, particularly in the conservation and management of marine and coastal biodiversity.