The Galaxy class starship was designed with the ability to separate the saucer from the stardrive section, so that the “floating city” part of the ship could be left somewhere safe while the rest of the ship galavants off to do something risky. We see this happen precisely once, in the season one episode Arsenal of Freedom. We also see saucer separation deployed for a handful of tactical and or emergency uses (such as against the Borg in The Best of Both Worlds, or to escape the breaching warp core in Generations).
So, this seems like a useful ability to have, and the Enterprise is constantly being sent into dangerous situations. Why not use this ability more frequently?
I think the saucer separation ability was an example of theoretical thinking. The Galaxy class designers clearly intended a use for it. In dangerous times, the saucer would separate leaving the stardrive section free to act without it.
But, via practical real world experience, Starfleet learned that separating the saucer section was seldom worth it. It was too slow, where danger tends to occurred suddenly, and, even when there was extra time, Galaxy captains learnt the extra power generation of the saucer proved more useful than the decrease in mass. I doubt the War Galaxys from the Dominion War even had the ability and, if they did, it was only because it would take too much work to remove.
It’s possible that the saucer section worked better as a one-use ‘super-lifepod’ but the original plan of combining and transforming ships clearly didn’t pan out. Same thing seems to have happened with the Prometheus with Starfleet deciding the ‘wolf pack’ attack more innovations, while effective, are better implemented via separate ships. Like we see a trio of Texas class ships doing to take down a Sovereign.
(There’s clearly some guy in the Starfleet bureau of ship design who keeps trying to make combining/separating ships happen and keeps getting disappointed when they don’t pan out in practice.)