Yes, the silicone will only stick to dry surfaces but is the best stuff for sealing glass aquariums. They simply use that statement to protect themselves from antagonistic people that want to blame somebody else for their own mistakes or stupidity when it leaks.
If you have a wet surface like an acrylic or glass baffle that needs to be bonded or strengthened, inside a wet or full sump superglue gel works. It bonds to acrylic and glass.
I agree with Roy. It's totally okay as long as it has no anti-mold/fungus ingredient. That could kill things in the tank as well as keep algae from growing. Not a good thing.
Edited by Mark Peterson - January 30 2011 at 10:25pm