Changing the view angle distort 3D tube image

Question

In previous post water inside 3d tube I added a code.

What I need is to have a look from front, but the problem is, if I change the angle from \tdplotsetmaincoords{30}{10} to \tdplotsetmaincoords{90}{10} I get a wrong picture with wrong overlap order of atoms like in image below How is possible to get a nice look from the front view, e.g. like in the image below?

Answer 1

The answer is given by Paolo Brasolin's code, see water inside 3D tube