I think it will, because Append itself has been made async-capable by one of the patches and UNION ALL uses Append. But as mentioned above, only the postgres_fdw foreign tables will be able to utilize this for now.
Ok, I'll re-run my test from a few weeks back and see if anything has changed.