I don't see a single innovative idea in this product and I see plenty that's worse than the experience I had in Dreamweaver in year 2000.
I am no fan of Amazon, but I do not think it is as bad as you describe. Even if it is half as good as Airtable, this will take off, simply because of Amazon's weight behind it.
With Honeycode being an Amazon tool, I would expect their targets are more enterprise. But even this tool is limited to 100k rows, so until that changes, this can't really be used at scale either.
There's still a gap in modern database apps combining scale, granular permissions and something made for non-technical users.
These little creepy 'useful' products are just vendor lock-in, the same way those creepy Internet Explorer-only features were 'useful', and forced the whole goddamn web development industry to complicate their tooling and made testing and providing the same experience across browsers a goddamn nightmare for decades (is it still ongoing? I thankfully escaped hell that is modern web development).
I'll probably be on my deathbed by the time these old idiot governments comprehend what these creepy IT companies have been up to since their inception.