I stayed in a different house in the same location for vacation last year, and this was a problem there too.
First, is this a US location?
Some small vacation destinations may have less stringent electrical code requirements than big cities and commonly"grandfather" older construction.
Do the wall outlets have the third "ground" position? Some receptacles may have the third position but it is not properly connected. You can pick up a ground test gadget at most hardware stores for under US$10, even in vacation towns.
https://www.homedepot.com/p/Commercial-Electric-Outlet-Tester-OT-112/321995342#overlay
A handy gadget to keep in your travel bag. If the tool shows a proper ground, then the Apple extension cable should work.
I have four of those US extension cables. Three came with older Macbook Pros and I bought a fourth for my travel bag. All are proper three-prong cables:

Apple still sells them: 1.8-meter Power Adapter Extension Cable
as does OWC: (*) 1.8 Meter (72") Apple Genuine AC Power Cable
Some pundits have said the the extension cable does not truly "ground" the power adaptor because there is no contact on the "duck's head. That is not true:

Metal strips tucked under both sides of the channel make grounding contact with the "nail-head" metal guide on the adapter body. Mischief managed.
How old is your Macbook Pro? The stack exchange question is about a 2008 Macbook Pro and I've seen more reports of the "Tingler" when "silver-key" Macbook Pros were involved.