you can imagine your medium as a sponge
you never want it neither soaked with water, or neither dryed out
just to keep it watered enough to give easy access to water for the plant, but not wet, because it will deprive roots fro oxygen
overly wet substrate will produce algae, bad fungi, gnats etc