Perhaps you could warm the solidified jars in a very low oven until they melt. Honey cakes sound like a great idea.

I have found it helpful to place the jars in a saucepan, water halfway up jars, set on the stove with low heat. Keep an eye on it and swirl the jars now and then to pull it all down from the sides.
Good luck with “re-distributing” your honey.

Honey cakes, honey shortbread, both of which can be made from non-gluten flours. There’s a bougie toast where you mix a spoonful of yoghurt, an egg, and honey to taste, then make a depression in a slice of bread, spoon in the mixture, place fruit on top and bake it for fifteen minutes. I think it’s this season’s answer to avocado toast. Make honey fudge or halvah to share with people. You can of course use honey for cooking and glazing meats and vegetables, and I love a spoonful on my morning porridge when I need something special. If I were close enough to visit, I would definitely help to remove honey from your house!

As for the rotten ones, maybe ask friends if they have a closed composter, or see if there is a professional compost company such as we have here? I can put literally any old foodstuff into mine, even if it’s questionable to eat (including “that didn’t work, did it?” experiments) and they have a huge composting facility that eats everything.

Ditto what Susan and Chris said about melting solidified honey, which is better for cooking than eating because it can re-solidify quickly.

Thirty-seven?! Wow, yeah, that is a lot of honeys. Definitely time to weed out the lesser ones. Think how much cabinet space you’re going to regain!

If I was closer I’d swing by and take a dozen off your hands, any flavor, any variety. I frequently put a little in my tea (when I get sidetracked and brew it too strong) or oatmeal, or on biscuits, cornbread, toast. A jar doesn’t last long here. Good luck!

“Doorbell ditch it.” You raised an undercover subversive. lol

Honey cake for Rosh Hashanah. Daughter Judith makes a killer one. I’m sure she would send you the recipe. Start celebrating!