No. Diablo II: Lord of Destruction (LoD) is an expansion pack. It requires the base game Diablo II to be installed, but not the physical disc in the drive if you meet one condition:
Installing LoD merges into your existing Diablo II install folder. It adds Act 5, new classes (Druid, Assassin), runewords, crafting, and raises level cap to 99. It becomes one unified game executable (Game.exe or D2R.exe for Resurrected).
Diablo II: Resurrected (2021) is a separate remaster — buy it digitally; no discs involved.