I came here to ask how to integrate direnv with magic shell but then some googling on the pixi site uncovered this super simple integration. Posting here in case it helps someone else.
This is the content of the .envrc file in the project folder.
if has magic; then
eval "$(magic shell-hook)"
fi