Auto Aim Bow code, Teleport Command Minecraft 1.13
Solution 1:
teleport works relative to the executioner, no matter if ~ ~ ~ or ^ ^ ^.
So you want:
/execute as @e[type=minecraft:arrow] at @s run teleport @s ~ ~ ~ facing entity @p
Note that this will neither redirect the arrow towards you (it has a Motion tag and to change that properly you need sinus calculation), nor will it actually rotate the tip of the arrow towards you, because facing directions of arrows are always a bit weird.