Nether Teleportation with Commands

Whenever I try teleporting to the Nether using the command
/execute in minecraft:the_nether run tp @s ~ ~ ~
in a different dimension, it would not teleport me to the correct position.
So, for example: Let's say I was at 8, 4, 8 in the overworld.
Then, I ran the command specified earlier.
I would end up at 0, 4, 0 instead of 8, 4, 8
It ends up acting like a nether portal instead.