Set artifact working directory to be in the destination store to prevent unnecessary I/O

Closes #33274

See merge request !11905