Why isn't it worth getting excited about? I get excited about lunch. It costs me nothing to follow the progress on low-probability, high impact technological advancements (see: space elevators, commercial fusion power, etc)
Human beings are not good at distinguishing between levels of "very low probability". Getting excited about space elevators is awesome, even though we're awfully unlikely to see them in our lifetimes and they might never pan out. But these drive theories are pretty literally too good to be true.
I'm just trying to say that our knowledge is incomplete enough that I would very solidly bet on certain "impossible" things being more likely than certain "possible" things. So sure people are bad at judging highly unlikely things, but even possible/impossible is not a reliable criterion. (As long as you don't cheat with hindsight.)