Stuart Brady and his wife were forced to tell their three children about their father's terminal cancer diagnosis "without even having the full information ourselves"