Success!
My friend Pedro Guglielmo pointed he could “revert” the mangling “reencoding” the text as latin1/iso-8859-1. I tried it naively in Python and got stuck with errors, but then I tried using a Python library called ftfy
from ftfy import fix_encoding
And it looks like I managed to fix a SQL dump of the posts table!