It does look very good, in my opinion.
However, I've played Diablo 2 + LoD for approximately 6 years of my life. I know every nooks and crannies, every classes and builds imaginable. I've tried it all, seen it all, done it all. If one day I do end up buying it on a sale, then I know myself well enough that despite enjoying the new visuals I wouldn't find in me the willpower (and probably not the time) to play the whole thing again. I'd rather just play Diablo 4 if I had to choose to be perfectly honest. Simply because Diablo 2 is a Hall of Fame type of game for me, and it doesn't "need" to prove anything more, be it in its original form or a Remastered form. It's Diablo 2, we know it's good and addicting and timeless. It's really a situation of 'been there, done that' for me.
The only reasons why I would be curious enough to play it again (and buy it on release, instead of waiting for a sale) would have been only if on top of Remastering the graphics, they'd have revamped many other things in regards to gameplay, skills, skill synergies, enemies, loot, new things in maps, new shrines and so on. Then again, if they had done that it wouldn't have been authentic to the source anymore; so might as well stick to D3 until D4 comes out (manner of speech at this point, because I stopped playing D3 on a regular basis about 2 years ago by now; I only check out Seasons when they release for maybe 2 to 3 days then I stop again).