It would obviously be an escort-type, so no science vessel inherent skills. As for a console, it could be the Assault Probes they used in the episode...too bad it wasn't shown what it is they do. Or maybe the bioweapon deployed through the phaser arrays.
And of course, owning one should unlock the relevant ship customiser parts for other Intrepid-class ships. Althoug