There are various flavours of Linux. Mint and Ubuntu are very similar, but Ubuntu is more Windows-like. Power users and techie gurus say Mint is more powerful. As others have said, load a Linux onto a USB stick and try before you buy (all Linuxes are free) to determine which one you are most comfortable with. All Linuxes use GRUB as a boot manager, which means you don't have to delete Windows to use Linux - you can make your machine dual-boot.
In windows, download a handful of Linuxes and then use RUFUS.EXE to make a bootable USB stick.
Ubuntu 22.04 LTS will run on a machine with 4GB of memory. Ubuntu 24.04 LTS really needs 6 GB or more to run, or it's really slow. If you're reviving an old machine that resides in the attic, 22.04 is probably a better bet. There is a new release every two years, in April (so 22.04 came out in April 2022, and 24.04 came out in April 2024).