You're running into one of those marketing issues with camera lenses where manufactureres label a lens "macro" when it really isn't. A true marco lens gets you 1:1 reproduction ratio or very close to that. On the Tamron, the reproduction ratio is 1:2 and really what the "macro" setting gets you is a shorter focal length. With the Tamron you still need to be at least 0.95m (according to the specs) away from the subject to focus.
You could try getting a set of close-up filters. They are filters that magnify the subject through the lens, kinda like reading glasses for your lenses. Picture quality isn't perfect but acceptable for all but the most demanding folks.
The advantage manual focusing gives you is the redction in the lag you get while the camera tries to focus. In dim lighting & with moving subjects what you can get is the camera hunting for focus which gives the moving object a chance to, well, move. What yo can do to get around this is to use the autofocus to focus on an area/object where you might expect the plec to be, then while holding down the shutter button (to holf focus) wait for the fish to swim into the area. Or, you could focus first & while holding the shutter, switch into manual focus. Finally, when you take the shot, set the camera to multi-shot mode & take a string of pictures at a time, often one of the string might work out for you.