Paul McCartney grilled Tina Knowles about what it's like being a mother to superstars Beyonce and Solange during the final night of her conversation tour