Cloud save is when your data gets saved to an account (like the one your device is set up with). SAving data to the cloud enables you to retrieve data on any device that uses that cloud account. Local save saves progress just the Terraria application.