Why does execute "as" not work in Command Block

Basically, I am trying to make a system so that when a player dies a dead body (armour stand with team colour) spawns 1 Block underneath the death spot so that when it is lying on the ground the legs are hidden.

I tried to use this command in my setup:
/execute as (player_placeholder) run tp @e[distance=..150,type=minecraft:armor_stand,name=Corpse] ~ ~-1 ~
but it only teleports my armour stand to the command block and not to my friend (player_placeholder).
It would be nice if someone could tell me why or maybe find a different solution for my plan.
Thank You