Any linux distro is significantly more lightweight than windows. But I'd say that there is not much difference between arch and for example the most bloated distro: ubuntu.

If you are a coder, the CLI will be easy. Most of the time the use of CLI is comparable to a single line in your code where you call a function with some parameters.

But arch is difficult for a beginner. (I wrote some more about my experience with it here: https://lemy.lol/post/61578059/24360161 )

If you have time, interest and discipline to read the documentation and learn a lot, then arch is great.

If you just want to use a Linux OS, install Mint and just use it. It's no big deal, just a normal OS. It's very intuitive, low friction and no microslop bloat.