Children in Wales are now afraid to go to bed when it rains heavily due to the “hidden scars” left by repeated flooding, the Senedd has heard.