I managed to fix some photos that were blurry simply using a super resolution machine learning algorithm.
The idea is simple. Down scale the photo. Until you don’t see the blurriness. Then apply super resolution. Its as simple as that. The result is not any way perfect but its better.
Super resolution should be in gimp I think.