David Howard had lived on John Street, Worksop, for 11 years when the massive explosion reduced the property to rubble on April 12, 2025, killing him and his dog