CS:GO is the more new player friendly CS. It has new weapons which were designed to help new players. Things like the P250 are easy enough to use without having to have reliable headshots (though obviously getting a one tap is still the best strategy). However, CS isn't like any other FPS because it basically forces you to learn the meta, maps, smokes, flashes, economy, weapon choices, strategy, rushes, common locations and spots to play, roles, aiming, spread patterns, etc if you want to get anywhere.
Also, I would like to say that CS:GO like any other CS game has heavy emphasis on the sacrifice of mobility for defensive/offensive capability. Whereas you used to be able to run full speed with a Deagle and still have the power to kill a guy with one well placed shot, CS:GO forces you to use the knife if you want to commit to full speed. Lighter weapons like the pistols will still give you close to full speed, but literally every single unit of speed could mean the difference of an engagement point and potentially give the enemy a large advantage. Movement is more than just speed though, since it really relies on you knowing map positions. Just walking along the other wall of a hallway could save you from a wallbang spray or an AWPer just around the corner.
It's definitely fun, but the first few months of play will probably be you learning how the game works.