Hello - The first thing to check if a Boolean operation fails is the curve(s) of intersection between the objects (Intersect command) Inspecting these will often tell you where there is a problem.
In this case the faceted blob has edges way out of tolerance so the curves of intersection are not closed. Explode, RebuildEdges (pulls them back into tolerance) and Join - you’ll see the result is not one closed thing.