The main value proposition of static site generators COMPARED TO 1st generation CMS like Wordpress is that they don't require a database and are lightweight and portable.
It is common sense that not everyone will want to run their own database and a server, so a wordpress.com makes sense.
But static sites can be deployed anywhere and there already is a huge ecosystem of vendor independent and free static site hosting sites like Github (which is subsidized by Microsoft), Gitlab, etc.
For Gatsby to survive and thrive in this ecosystem that is completely different from the wordpress ecosystem, they will probably need to do a lot of things to create a lockin, in which case there is no point in using Gatsby. After all, all Gatsby does is just compile some files into static site. Nothing magic in there.