While Hardy's book is still relevant, there is a more modern attempt at answering the same questions for those interested: Mathematics without Apologies: Portrait of a Problematic Vocation by Michael Harris.