Extension tubes have their purposes, but what you're looking for is not one of their purposes. Extension tubes allow you to focus on items, CLOSER than the lens would allow you to focus on them, otherwise. In other words, each lens has a Minimum Focus Distance. This distance is normally measured, from the camera sensor to the object. Let's say that distance is 8" and let's say that the lens is 5" long. So, now you can focus on an item 3" in front of the lens. So, slap an extension tube on and this cuts the Minimum Focus Distance down to about 5"-6", this varies according to the extension tube. Now you can focus on an item 5"-6" from the camera sensor, but you're still shooting with a 5" lens and the added length of the extension tube. No benefit at all, for aquarium macro photography.
Also, another drawback, to using extension tubes is that less light enters the sensor. This means that you have to shoot at a slower shutter speed, higher ISO or wider aperture setting.
One more drawback, is that the use of an extension tube creates a razor thin Depth of Field. This means that, if you're taking Macro shots of a coral, a couple of polyps will be in clear focus, while the remainder of the coral will be out of focus. Because of this, with an extension tube, shooting macro, you'll NEVER want to hand hold. You'll ALWAYS need to use a tripod.