I'm not sure if Agile ever claimed to be a good process for coming up with unicorn startups though.

It's a way to meeting actual business software needs, much more suited to custom development for one customer than product development, which necessarily requires some additional insight into what the market wants.