There are multiple tiers of lightweight.

“Middleweight”: Something like Kubuntu, Xubuntu, or anything with KDE or XFCE, or MATE

More lightweight: Lubuntu, anything with LXQt

Super lightweight: AntiX, something with Trinity Desktop Environment or just a window manager instead of a full desktop environment

Most lightweight: Just a command line with no GUI (barebones Arch maybe?)