I've been 5 times while camping with Cub Scouts, but the last time I went was around 2017. IMO, the most enjoyable part was visiting with the amateur astronomers and looking through the telescopes they had set up on the observation deck. Some of them had really impressive setups. I'm not sure if amateurs still set up there or not.
Every time I went, they had the big telescope focused some really distant object that just wasn't very impressive to look at because it was just a white speck. We would have much more enjoyed the big telescope focused in on something close and familiar (Moon, nearby planet, Saturn's rings, etc.).
Brazos Bend SP is a great place to camp, especially with kids. You get to experience different ecosystems (swamp/marsh, grassland prairie, forest). They have an extensive network of hike & bike trails. The programs offered by the Nature Center are some of the best I've experienced at a state park, especially the guided hikes.