I have similar thoughts as you do. I work with applications in the financial sector, that I don’t feel are meaningful enough to get my motor started really.
It sometimes helps to start small, find a task that can get completed quickly? It doesn’t always work for me.
I would also like to transition into another career (I’m a lot older than you are). Eventhough I dislike it myself, and haven’t yet found a good way to do it - maybe a way would be to start something on the side, just to see if you like it.
Take a distance course in something related to pharmacology for example. If it’s not possible to do on the side, would it really be possible to do full-time? And if so, why is that? Just some thoughts.