Its an interesting product. For someone using Aurora Postgres though, it leaves lots of unanswered questions about compatibility. This page they link to is basically a landing page with no details: https://fauna.com/postgres.

My read on this is "if you already use postgres don't migrate, but if you want to use us for a new application that is a good fit."