Hi, thank you for the file!
If you Instance a Cube instead, you can see the problem:
These Cubes rotate correctly, so the Tubes use those locations as Pivot Point. You could correct that by changing the Y to something near -0.4m (you’ll probably know the exact number). There are probably other places you could change something to make it work, but that is up to you now.