Yes and no
It is stored in the cloud but you can have it locally on your iPad as well. Think of it as a backup facility. It is ideal if you have more than one device as any things you want to share, for example a photo you take, will then be available on the other device
You get a certain amount of storage free (5 GB) and after that there is a charge - not a lot though