Why i cant punch a hole through the mesh?
This is essentially a shading issue: use autosmooth in the property panel. That will avoid the rendering to be annoyed by the normals of the faces created by the boolean.

To fix the little tube that goes bad, just shift it a bit.
Also the tubes are opened at the bottom. They should be closed.