Add a site deletion command and handle missing folders during restore

Adds a `pilot drop-site` command with a confirmation step, and restore recreates missing folders.