When using the boolean modifier, the resulting faces disappear when applying the modifier
This is a somewhat older link, with instructions likely intended for 2.79. But the answer given by zeffii is an amazingly good primer on the subject of booleans in Blender, which demystifies them by covering all the likely problem situations, as well as their remedies. Very much worth reading, in my opinion.

The Boolean modifier is not working