I have tried the node, the rotation is correctly locked but still it just moves in that weird line. Here is what I got:
Alse here the first time I attempted it(wrong) lol:
Thanks for the suggestions mate. Think I might try to redo the project in mostly code, hopefully I get less issues that way.