So I've found that downgrading the Azure Web Deploy version from v3 to v2 in the workflow file solved it and it now deploys successfully. This is obviously not a long-term solution and I want to use v3 so if anybody has an idea what's tripping up the newer version, I'm all ears!