Procedural mesh destructible

You can do this, if you calculate the fractured meshes yourself probably using a Voronoi algorithm.
Here’s a tutorial on procedural meshes:

The fracturing algorithm that exists today in the engine can only be used in editor, not at runtime. They have mentioned that they want to make it so that it would work at runtime in the future, but not sure when.

So you could look at the algorithm already used in the editor and make that work in real time.

But yeah, it’s possible, depending on how much work you want to put in it. If this is a main feature of your game, it’s probably worth it to put in the time. If not, just use the built in way.