It could get a bit preachy, honestly.

But also not unusually so by 80s/90s television standards (TNG).

Back then writing on popular network TV shows could get away with beating the viewer over the head with a lesson/moral explicitly explained by a character with delivery about as subtle as an after school special. So a lofty Picard speech or whatever wouldn't stand out much from whatever else you'd see that night.

DS9 is still pretty earnest but you can start to see the evolution of writing/viewer taste as you get closer to the 2000s (also the freedom to follow the formulaic episodic structure of network TV a bit less rigidly).

That was a feature, not a bug.