No, deleting the app does not automatically cancel your subscription. You need to take further action to cancel your subscription. Please see these FAQs for help cancelling:
How do I cancel A&E Crime Central?
How do I cancel a subscription purchased on aecrimecentral.com?
How do I cancel my subscription purchased through Apple's App Store?