Linking to another thread on Pixel and eSIM issues (but theirs is related to registration failure).
In your case, are you still in Canada where you can re-test that eSIM? I would appreciate a re-confirmation of what your APN settings are in the non-working eSIM and with the working physical SIM (also Airalo?).
Also there is this older one related to a Pixel8 and eSIM not sure if worth a try: