I don’t think those requirements will be met until people like us who miss it put our money where our mouth is ;)
I think people like us (at least me) miss a lot of things, some more important than others, and we have to carefully choose what we spend out time on :)
I'm about to open source it now. Which means I just did, but haven't announced it yet. https://github.com/pipes-digital/pipes now contains a very new version you could run locally.
r-w is right though: More users paying for pipes would allow me to invest more time into it and have more requirements covered.
What I likes with Yahoo Pipes compared to NodeRED (at least as far as I looked at NodeRED, I might be wrong) is that Yahoo Pipes worked out-of-the-box with services out of the box. I seem to remember that you could use the Google Search API for example, with Yahoo Pipes and pipe that into other things. That's what Zapier does as well, but with less flexibility than NodeRED.
So I guess my dream would be something like the integrations provided by Zapier but with the UI and flexibility of NodeRED.
Haven't seen pipes.digital before, I'll take a look as it looks interesting, but for anything serious, open source is a hard requirement (gotta learn from the Yahoo Pipes history :) )