On his poignant second album, the multitalented singer-songwriter gives voice to the self-doubts that manifest in the wee hours of the morning.