I loved the visuals but space elevators are far more science-fantasy than hard science-fiction. We should move on to sci-fi tech that has more realistic applications.
Only for Earth. We already have materials that can do it on the Moon (Zylon, for example), though not with great tether-to-payload ratios (200:1 or more), and Mars isn't too huge of a stretch (huge like the mass of the tether, which would be in the thousands to one tether-to-payload ratio. Shipping 50,000 tons of Zylon to Mars is a different beast)