I'm confused. You wrote above that loading without indexes and with just the PK works just fine; if you really need it loaded in Aurora or production, just drop the indexes beforehand?
Because the jsonb_path_ops index does not rebuild, and it’s the heart of that table.
The table is essentially worthless without that index to us.