From my perspective, the "obvious" use of Maintaining Momentum is to put it on an aggressive or reckless officer, then put the extra skill (also from this mod) to allow one officer to pilot an AI ship on that same officer, and toss them into a Radiant, or perhaps the unique automated Onslaught or the like. (And if it does get itself killed... well, it's an automated ship. You won't lose any crew from the problem; recover it and keep going.)
That said, you can get an officer with MM during gameplay, and can only tag one officer with the 'can run an AI ship' skill, so if the plan is to use heavy automated ships then it's probably better to invest in Auto-Engineer for your Comradery choice.