These philosophical, sometimes grumpy journals, unearthed after the doyenne of suspense fiction’s death, shine a light on her dual identities, the contempt she felt for other people and her erotic misadventures