When Patrick Stewart signed the contract for “Star Trek: The Next Generation”, he believed the TV show would quickly fail