You need access to a server to compile the code and run a full node of the Steem blockchain. When connected properly, the cli_wallet is a tool for communicating the commands that you want broadcasted onto the blockchain.
Definitely a tool for power users, but it's possible to learn! There are some good guides by @steemd and many others that exist to help the newbie understand more.