As a lens to add to your collection, it's "okay." It's not a macro lens, despite what it says.
Macro (or micro in Nikon speak) is a lens that does 1:1 magnification. That means that the image of your subject projected on your sensor is the same size as the object. That lens only does 1:2.9. There aren't zoom lenses, that I'm aware of, that truly are macro lenses. For aquarium work, a lens in the 90-110mm range works pretty well.