So the pivot on the spot is good, the pivot on the base is not. You’ll need to put a scene component on the base to correct it ( because ‘look at’ always assumes X is pointing forward, and the base is using Z ).
Then you can use ‘look at’, but you’ll need to limit both of them to some axis only.
Bit busy now, but will come back soon 