The Aquarius escort console gives you a ship exactly like the lolquarius failstroyer in the shipyard. For it's tier, it blows, it's squishy, and as you said, it's AI don't work so good. Also it's damage isn't high enough to make it worth it. I agree with rdm, just take it off and put something more useful on, like an assimilated universal console or a field generator.
I have to disagree with the above user. The Aquarius does have usefulness but like the Odyssey it self, its about knowing when to use it and when not to. If you are a player who has managed to output decent DPS in the Oddy, the death of the Aqua will occur less frequently.
First, its a combat pet which means it's meant to be a bit of a redshirt compared to the main vessel. In fact combining it with other space combat pets (ie. Scorpion Fighters) will actually increase its longevity as enemy targets will spread firepower more.
Second, the best time to really use the Aquarius console is to wait until a target has low or no shields before deployment. Then the little escort will drastically up it's deadlyness as it works very well against unshielded targets. An easy way to tell the difference is to see the synergy it has against shielded vs unshielded borg targets like a Tactical cube. It lacks the ability to really effect the Borg shields but it will do great damage against direct hull.
Thirdly, it's a great trash mob clean up ship. It's PDS console and Quad cannons means it will take care of annoying spam mobs like Frigates or Fighters allowing you to focus on that dreadnought in the background.
Lastly, as has been pointed out pretty much every where, this is not an "I win" button. It is meant to compliment your ship's DPS levels. The Oddy is not a carrier, this is really meant to be treated as a power like Beam Overload or Scatter Volley.
Lets throw away your assumption that i am a noob and stick to the facts.
AI is bad, we get no control over it and its very squishy.
In PvP i am able to tank up to 3guys in most situations and in pve i can tank negh, raptor and a cube with little or no assistance from my team mates and on my dps i am mostly top, i have played many space games before including STBC and that kinda stuff.
So please, lets talk about aquarius and not say: "its a win button"
Im trying to discuss the aquarius itself, about its AI, needed action bar for it, and perhaps just a bit more survivability...
Personally, all I use of the Odyssey 'Aquarius' is the bridge. :)
I use chevron separation myself. Saucer can die easily too, but, unlike Aquarius escort, its boon lies not so much in the saucer itself, but rather in the improved mobility/weapons buff of your main vessel. In that sense, chevron separation is like the D'Kora battle-mode console (but with a visual extra component: namely, a separated saucer). If the saucer happens to get off a few useful shots too, great! If not, no biggie either.
Ok, putting aside my previous comment (even though I stand by it), I will agree to return to the original topic. EVERYTHING needs an improvement. The AI is terrible, I agree, the ship itself is not nearly as useful as it could be, and as for controlling it, or if not controlling then directing it, yes, that could be useful. After all it, is an ESCORT, so it might as well do it's job better by being where it needs to be, when it needs to be there, and not get popped on route to said location.
Basically on OP, I agree. MAKE IT BETTER OR GO HOME.