Aurora is one big database, isn't it? PgDog is just a proxy where you tell it which shard to access.

Yes, except it doesn't have any cross-dependencies on the same volume, so the uptime here should be higher.

Aurora has a completely different storage backend. PgDog is a front end proxy - each server in the cluster is still using standard Postgres right?

Yup!