Does the Apple product need to be connected to the internet to work?

No.  However, connecting to the internet enhances the pilot’s experience by offering features like continuous background imagery.  The system will work fine without a connection and will even cache some maps if they are pre-loaded in areas where the aircraft has a connection (from places like the hangar Wi-Fi)