delete subscriptions from db on cancellation

[chdsbd]

This helps prevent a Kodiak UI issue where a user still sees a subscription when it's actually cancelled.