About the "SD-Card that has little-to-no wear levelling and it won't last long",
also a standard Rpi4 could have the same problem ?
Not could, but does have the same issue.
The only difference is that a pi4 has the option to come in variations with more memory which reduces (or can reduce) the number of writes to the sd-card. If you have a pi4 with enough memory then consider compiling to a ram disk or use a (USB) attached storage device that is more robust.
Plus modern SD-Cards /might/ be more robust. But apart from that: /all/ devices which write to an SD-Card have the same problem unless they're using a filesystem designed- from the ground up- to have its own wear-levelling. Swap is particularly brutal, and this has been an issue since the Pi-1.
I think it was the Pi-3 which introduced the ability to boot from USB-connected media, although it was disabled by default. But in any event it's never been difficult to boot from card but mount external media a the root device (i.e. /) although there's obviously a possibility that an version of Raspbian that wasn't expecting it might be unhappy e.g. applying updates.
In practice, I've got an RPi-3 here driving a 3D printer etc., it boots Buster from "spinning rust" and apart from font metrics issues that I think I've mentioned in another thread I've never had any problems.
MarkMLl