Do not use water for this.
When using a soldering iron, the sponge should be damp, but water is not necessary. A damp sponge can help clean solder slag from the tip and ensure heat transfer.
You can moisten the sponge and place it on the soldering iron stand. Then before using the soldering iron, you can lightly dip the tip in a sponge to keep it moist.