Nuclear thermal rockets have low specific impulse compared to electrical propulsion, but better ISP than any chemical rockets. They also provide orders of magnitude more thrust than electrical propulsion does. I don't think that they are in the sweet spot for uncrewed probe missions, but the combination of higher-than-chemical ISP and higher-than-electrical thrust seems like a good match for crewed missions to Mars or beyond.
Regarding the many comments in this discussion about accidents during initial launch: if nuclear thermal rockets are fueled with uranium 235, and don't reach criticality until after the risky chemical-booster ascent out of atmosphere, they should be quite safe. Uranium 235 has a 700 million year half life, hence very low radioactivity. The fission products from a live reactor of course include very-short-lived, very-high-radioactivity nuclides. But you can have nuclear power in space with extremely low risks to the terrestrial environment if you use it only for missions that leave Earth orbit, and turn on the reactor only after the risky initial ascent on chemical boosters.
That said, I agree that it would be expensive to develop nuclear thermal rockets. It's very expensive to test them on Earth, since the exhaust carries away some small amount of fission products and people don't just tolerate such radioactive pollution like back in the 1960s. You'd need some very expensive/elaborate test facility that can capture the hot, radioactive exhaust, or you'd need to do all the actual testing in space (also expensive/elaborate).