AWS Aurora itself is a proprietary database built and maintained by the AWS team. It’s not a database we directly support thus we can’t promise it will even work there.
If you want to use a supported database on AWS we recommend AWS RDS: Amazon RDS | Cloud Relational Database | Amazon Web Services
We ourselves within Strapi use it and regularly run tests in AWS including with RDS for PostgreSQL, MySQL, and MariaDB.