What I found to be extremely helpful, over really everything else, was seeing a therapist and working through the feelings that I had. In my case, what I realized is that I did not actually despise my job nor was I actually burnt out. Instead, I just lacked balance and fulfillment in my life.
Throughout the course of these therapy sessions, I looked inward and ended up stumbling on a number of new hobbies. All of which were in the physical world and, at the time, were a lot more fulfilling than software development for me. Things like auto detailing, fixing and improving things around the house, BBQing, etc. At one point, I remember myself literally jumping for joy after hanging a bike rack in my garage because I was so excited about it. I found that after exploring these, my love and desire for programming and software development started to return and I felt hungry again.
Reading your post, I don't think that you're weak or unreliable. It sounds like you're changing as a person and haven't been able to put your finger on what makes you happy now that you're older. People with good jobs and good income aren't insulated from feeling this way, and by no means should you feel ashamed for it.