The overall sentiment expressing the growing gap between software needs and hardware capabilities is sound. This is where FOSS projects shine who put deep thought into providing the same features modern users need into an OS that can intelligently utilize older computing resources. I've been in the industry since the Nineties and it still amazes me how many companies invest so little into backward-compatibility and performance during their OS and application design process.
I've had my Panasonic Toughbook (CF31-5) for almost 10 years and while it's a dinosaur to some, it's a major upgrade from what I had before in terms of portable computing. Its max memory is 16 GiB DDR3 SDRAM on an Intel Core i5-5300U. When I first bought it I tried Debian and Ubuntu, but even back then those ran slow. I installed Xubuntu and have run that ever since with no performance issues whatsoever.
Because I primarily use Emacs and TeX tools, writing Elisp and LaTeX, the system is more than enough for me. I've not played graphics-heavy games, run GPU-intensive UI or done any heavy data plotting. However, one benchmark I do have: I am able use the test automation framework required for my day job with ease. I run that software on Xubuntu because on my work-provided systems (Windows 11 and macOS Tahoe) the application crawls and is practically unusable.