It sounds as if you have identified an area where you can work and be valued - academia may rate research and published papers highly (and so it should), but there is also great merit in being an educator.

Sounds like sufficient motivation to face your advisor and give it another crack. A setback hurts and can take time to overcome, but you have done that. Good luck.