Why does execute "as" not work in Command Block
Solution 1:
The as subcommand only changes the executing entity, but the position does not change, meaning the position will still be at the previous executing entity. You need to use at @s to move the position to the target entity. Like this:
execute
as (selector)
at @s
run
tp @e[distance=..150,type=minecraft:armor_stand,name=Corpse] ~ ~-1 ~