This is a sound that people make when they see something really cute. People especially say "Aw!" when they see cute babies or cute animals. Children and women use "Aw!" more than adult men.
This is a little different from "Aw" as it's used in this lesson:
Aw, you're just saying that!