Can’t you bypass CAP if you just have a ton of compute in the background handling all of these tasks in real time? Aurora isn’t just some binary running on ec2 it’s probably 10 different things going on
CP means you can’t be available, meaning your system will stop replying to queries.
AP means you’re always available, but you could receive stale data when querying.
It’s irrelevant whether it’s a single binary running on EC2 or a billion services working in unison. It’s a property of the system.