This is addressed in The Rise of Skywalker.
A Resistance character suggests using "the Holdo maneuver" against the First Order, but another one dismisses the idea, saying it's a "million to one shot". It's not addressed further, but we can surmise that it's not guaranteed to work, so can't be relied upon as a usual tactic.