Yes if you cancel the subscription for the Scribd app then the downloaded books will also get removed.