We use Amazon RDS for Aurora because we needed a cloud level scalable solution for database management. We wanted to use a modern database engine that's suitable for the cloud era and also benefit from using SQL and a structured database.
We never wanted to manage the DB infrastructure ourselves so our choice was between Aurora and simply RDS. We chose Aurora because of superior performance and the ease of scaling storage and instances.