This a known limitation.

Result can be unpredictable int the case of open volumes.
https://docs.blender.org/manual/en/dev/modeling/modifiers/generate/booleans.html#known-limitations

To have a good solution, you need two closed volumes as operands.
In your .blend file, you just have to add a Solidify modifier before Boolean modifier.