Martha Wainwright’s ‘Come to Mama’ was inspired by her mother’s death and her son’s birth, writes Tina O’Sullivan