Currently it is in the hands of Mike Flanagan, who previously worked on Midnight Mass, Doctor Sleep (a Stephen King adaptation that was good, and Fall of the House of Usher which is a Poe adaptation which was also real good. Given all the stuff he has worked on (good and not so good) I think he is perfect for it.

As far as longevity I really hope his take on it lives up to the hype because there are seven very dense books to adapt (excluding Gunslinger which advantageously was originally written as a standalone story and is fairly short).

They could both milk the series for a lot and also result in a very great adaptation since there are a few novellas too. It's both a blessing and a curse that there is so much material because it's going to require some incredible creative vision but also has the potential to span a decade of television.

And unlike GoT this epic fantasy tale actually got finished...