'Big Bang Theory' star, who is already slated to host prime-time and spinoff series, will take podium long occupied by Alex Trebek