When you try boolean add/subtract sometimes you have to do it is phases. All vectors must overlap for boolean to work. So if trying a boolean try half of your objects first and then do the other half. Usually trying to do a boolean on everything at once does not work. It is clunky but doing it in phases works. @WillAdams editing nodes works as well. There are many to skin a cat but in the end you have a skinned cat. Booleans can be tricky and in 6 years and the many changes to boolean in CC I still do not fully understand but I always get what I want in the end using multiple steps.
If you commit your boolean and it is not right just use Control Z to reverse. You can do Control Z multiple times to reverse multiple steps. Not sure of the limit of times Control Z works but is a bunch of steps.