I’m not a computer expert or planning to be. I’m just a computer user, a coder, a gamer, and I think I will get the opportunity to afford cheaper PCs if I use the Arch distro from Linux which is very lightweight and fast. I’ve heard Microsoft forces you to bloat your PC with win11.
I think the whole “XYZ Distro is faster!” arguments are overblown. Most distros will be fast enough on reasonably modern hardware, and any performance gains will usually come with compromises and/or lots of tinkering. Generally speaking a standard arch install (that is, you’ve not manually configured anything) will be roughly the same speed as a more beginner friendly distros like Mint and Fedora (which is still more lightweight than Windows).
To answer the question in the title: Yes you’ll survive the CLI. Just give yourself time to learn the fundamentals and treat it as learning a programming language. More user friendly distros generally don’t expect you to use the CLI, which is part of the reason they are recommended.