Use the right DLLs and pkg-config path on Appveyor

We want to future-proof our Appveyor CI against dll and pkg-config issues.

Split off from #33643 (moved), which is the urgent CI fix.

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information