The artist’s new show does the hard work of trying to make the intimate large-scale and the big questions personal.