No it will kill everything in the aquarium...
Some people need to learn the hard way I guess.
This is from their website.
Don’t use Amazing GOOP on items that come into contact with your household pets or animals, such as aquariums.
Don’t use Amazing GOOP on items that come into contact with food or drinking water, such as your dishes.
Don’t use Amazing Goop on your dry cleaning. The dry cleaning solvent breaks down the adhesive.
Don’t use Amazing GOOP on styrofoam or polystyrene (because it will cause them to dissolve), or on polyethylene or polypropylene plastics (because it will not adhere well).