I don't think that for instance MS Access has failed. It was and still is a very good solution when it comes to creating line of business apps (within days) that have forms, reports and database access (for teams with up to ten members). These teams don't need anything that is more complex than that.

I don't know better solutions for developing RAD (rapid app development) apps for companies who are running on the Microsoft stack and who don't have dedicated dev teams.

Now for them Google App Maker is a very interesting solution.

Actually Google addresses these kind of users explicitly in their early access application form.

I don't think that this platform was intended to replace Frontend Development, React, Angular, etc