The main effect of hydrological drought is a significant decrease in water availability in rivers, lakes, and groundwater sources. This can lead to reduced water levels, drying up of water bodies, and limited access to water for various uses, impacting ecosystems, agriculture, and communities.