Rotating texture in node mapping make texture gone after rotate more than 90°
I think you should rather try with the Texture Coordinate "Object" output, it looks much more controllable than Generated. Here for the manual explanation. Also don't forget to apply the rotation and scale of your object if you want the object axis to be aligned on the global (ctrlA).