We had a sewing machine like that. It was broken and rather to spend the time and effort to fix it (not my thing) we bought a new one and gave the old one to Goodwill.
The knee controller was just too weird (even if we had gotten it to work). I’ve osteoarthritis in my hips and I don’t think it would have been fun.