Yes, you do need an active internet connection in order to activate your eSIM. Best idea is to connect to the Airport WiFi from your source Airport and activate the eSIM or connect at your destination Airport WiFi to activate your eSIM. If the validity of your plan is longer than your stay, you can activate the eSIM on your device just before you leave home.