I understand your point you're making but the reason why they operated in the dark or with a red light was two fold. The red light was such that they could see without affecting their eyesight when going outside. Also being blacked out was needed as the enemy could easily see them.
In space, there's no need to protect your night vision, nor would the need to have a blacked out ship when the distances are so vast, i.e., they're seen on sensors well before they can be seen visually.
Its not like they producers are going for realism, since there are no faster then light ships. JJ Abram's Star trek uses quite a bit of light - the bridge is blaringly bright compared to TNG/TOS.
I think it ruins the watching experience, but then I'm not a paying customer so I have zero say. I only see snippets that make their way onto YT.
JJ's Enterprise bridge looked like an Apple Store. I kept expecting Kirk to bump into a table of MacBooks But I think a lot of Titan's bridge has dark bulkheads and control panels, black and dark gray, making it look darker on film than it is. Enterprise D had a lot of light colored bulkheads, tans and such, making it look brighter than it was.
Plus, I think Picard Season 3 has some really dark themes going on, so the production team made the ship gloomily equal.