Graham Mansfield testified in court that his terminally ill wife asked him to kill her when "things get bad" following a terminal cancer diagnosis