xbps uses /tmp to execute the pkg install scripts, so no, it's not possible to mount it with noexec for now.