I had a somewhat similar experience moving from science to data science/engineering. A PhD meant I fit your description of "overqualified, but in the wrong area". Those days were hard and hugely demoralising. Until my résumé landed on the desk of someone who'd made the same career change, I was SOL.