Because it is the account of someone who knows what he should do and cannot want it, and it describes this from the inside with rare precision. In Book VIII Augustine's intellect is already convinced and his will does not move: he recalls that, as a young man, he had asked for chastity "but not yet," says "tomorrow, tomorrow" and sees himself divided between two wills (Book VIII, chs. 5, 7 and 12). Anyone who has put off a decision they knew was right recognizes the scene.
Because it asks questions that remain open and thinks about them in front of the reader: why someone does evil with nothing to gain from it (Book II), what memory is and how we remember what we have forgotten (Book X), what time is, which everyone knows until someone asks (Book XI).
And because it is a book about friendship, loss and grief: the death of the friend of his youth, which turns his native town into a torment (Book IV), and that of Monica, after the conversation at Ostia, when her son holds back his tears at the burial and weeps only when alone (Book IX).