"Why were ships so fragile in DS9?"
They weren't more fragile than in any other series.
The difference was the enemies they were fighting: NOT aliens with tech 3 generations behind starfleet's.
A direct hit by a dominion high power energy cannon will punch right through starfleet shields - as seen on multiple occasions. The opposite being also true.