My problem is the TNG aesthetic set up an expectation which was never again adhered to, specifically with the bridge.
The idea behind the design of the bridge was that Starfleet in the 24th century was so advanced that many of the ship functions were automated. Leaving aside the fact that such a level of automation clashes with the 1000+ crew (if automated, why do you need so many people?), later shows and ships attempted to portray themselves as more advanced by having more bridge consoles. However, more consoles should equal less automation which should equal less advanced by the TNG formula.
Consider Voyager or the Enterprise-E. They both feature far more control consoles than the D did, with the E's bridge being almost wall-to-wall with consoles (how many tactical stations does the bridge of an explorer ship need anyway?
I don't like riding in and defending the 1701-E (because it's
far from being my favorite ship

), but the obvious answer to this is "The E isn't an explorer ship, it's a battleship; and Starfleet is at war".
Of course, that doesn't answer your broader point that, yes, it seems silly that they seemed to go backwards on the automation front. Let's not forget that it was the 1701-E which gave us the 'manual steering column', the ultimate in hands-on control.
Another quibble of mine: where has this notion come from that the E was a battleship?
I'm going to ignore
Nemesis and the absurd modifications to both the CG model and the in-universe ship for a second and break down the era in which the E was launched.
Dialogue in
First Contact indicates that the E was launched in 2372, or during DS9's fourth season (shortly after Worf joined the show; he's always so impatient! He missed the new
Enterprise by that much!)/VOY's second season. We don't really have reliable canon information which suggests how long it takes to build a starship, but let's assume that the keel for the E was laid down a year previously, or in 2371. The Federation was not at war in 2371, so why assume the E was built as a battleship?
Yes, the Federation had made contact with the Dominion. However, unless construction on the E began after the events of "The Die is Cast" (indicating that construction began pretty late in the year), the Dominion was so far only a hostile neighboring power on par with the Romulans. "Die" was the point at which it was cemented that the Dominion was a substantial threat with whom negotiation might fail.
Even after "Die," why modify the design of the E? There was still no indication that the Dominion might invade; merely that they should be left alone in the GQ.
I don't buy that the E was designed as a battleship. La Forge's line about being the most advanced ship in the fleet wouldn't necessarily only refer to the ship's offensive capabilities.
Moreover, I don't buy that the E was designed as a battleship because the
Defiant and the rest of her class were treated like this novel, crazy approach to shipbuilding (Kira's incredulous line about Starfleet building a warship being a prime example) which was not duplicated until the
Prometheus.
No, the E was the most advanced starship in the fleet like the D before her. But, the
Galaxy class wasn't a battleship either. They were designed to explore, and I think it's much more likely that the E and the rest of the
Sovereigns were as well.