Returns whether the session is in terminal state.
Cancelled, Succeeded and Failed are considered as terminal states.