The ACK operator runs in k8s, but I'm pretty sure RDS instances created via ACK will still run natively in AWS.
ACK is a just a k8s native mechanism for defining the resource and managing its config/state.
More a replacement for Cloudformation or terraform.
Source: I read some stuff and am not 100% confident.