This looks similar to Airtable, except Airtable UI seems nicer. Airtable is a Billion dollar company, tons of people are happily using it.
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.
I agree, the users of Airtable love the UI. But it's mostly individuals and small companies. Airtable isn't practical for enterprises with its 50k row limit and extremely limited permissions.
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.
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.