40
isolytic burst warheads (Specifically banned by Khitemer Accords, used by the Son'a, REMEMBER THEM?)
88
plasma torpedoes, (As used by the Cardassians and Romulans to great effect.)
236
photon torpedoes, (nearly as many as the Galaxy Class)
18
antimatter missiles, (Sending Suns Supernova since 2256)
20
pulse wave torpedoes, (Potentially deleting systems since the 22nd Century!)
(Stolen shamelessly from Memory Alpha)
AND MORE unknown to Fed scanners, including the Portal Weapon.
So it's a liiiiiiiiiiiiitle more well armed than a Galaxy at 260 and the Soverign at 300.
Neo Connies don't currently have a nailed down stats sheet I can find anywhere on t'internets right now, but it's only got a crew compliment of 500 in the post-dominion war Starfleet Era. She's got a smaller crew than the soverigns and is likely her footprint overall is smaller too. She's also clearly not designed to the more "warship" feel in an attempt to recapture glory days of a major superpower grown somewhat fat from a good 20+ years of peace.
Antimatter missiles are causing suns to go supernova?
Since when?
To my knowledge photon torpedoes have antimatter warheads... they ARE in effect antimatter missiles... and they're not supernovae inducing by default.
Trilithium torpedoes on the other hand can force a Sun to go supernova because Trilithium as a compound is a nuclear inhibitor.
Also, Trilithium can be infused into Quantum torpedoes (as was done on DS9 to poison Maqui planets)- and can probably be infused into Photons as well).
So... I don't see the advantage of these at all.
Plasma torpedoes... eh, they were extremely effective in the 23rd century... not so much in the 24th. In this era, they seemed to have been no better than photon and quantum torpedoes - and UFP shields were able to enact a protective effect (unlike in the 23rd century).
Isolytic burst weapons... sure, they can tear holes in space... those would be dangerous... but the way they were initially presented in Insurrection was that they COULD tear holes in space... not always. They were unpredictable, hence why they were banned (and again, one would imagine SF would have come up with some sort of viable defense by now - plus, any idiot stupid enough to carry them runs the risk of getting themselves pulled into that subspace tear too if they happen to fire them and lose control).
Regardless, the Galaxy class had 260 photon torpedoes, and it could probably be outfitted with Quantums as well (especially by this point in time, and a ton of other stuff).
At the very least, the Galaxy would have been better equipped to go up against the Shriek.
Plus, as slow those photon torpedoes moved, you could seemingly evade them easily enough... the ones in TNG, Insurrection and Nemesis moved much faster at sublight. And the Galaxy class could fire 6 of them at the same time in a Sierra pattern.
Fire enough of them at the same time at the Shriek and it will probably/eventually go down - because the Shriek didn't seem like it was capable of firing 6 of them at the same time.
The Titan-A seems to copy the Constitution class in terms of ineffectiveness when it comes to shields and slow moving torpedoes and overall maneuverability (the galaxy class was far more agile).
Eh... like I said, 'warship' is a bit of an overstatement.
It certainly packs more ordenance than the Galaxy class, yes... but in terms of individual fire power, I wouldnt say those are particularly deadly weapons (sans perhaps Isolitic weapons).
In terms of individual firepower, they are probably on par with modern photon and quantum torpedoes... so the only thing those add to the Shriek are numbers of ordenance... and given the size of that ship, you'd imagine that SF would also be capable of giving its exploratory ships more than enough torpedoes and powerful shields for proper defense should the situation arise).
You can still be peaceful and not fire first even with a plethora of tactical systems for powerful offense and defense.
It would only be sensible to start equipping exploratory ships properly and not uner-equipping them.