Biggest differences are that Neon can scale to zero (and not charge you) and it has branching as a native concept. This means that it can provision a new DB nearly instantly (as opposed to waiting a few minutes for Aurora) and it can do instant copy on write branching.
So Neon is a lot better for AI agents that are running experiments.