I was in a similar position, working as CTO under a first time CEO where we built a small team, product, got some limited traction, but follow-on execution completely failed. It was incredibly hard. It depresses me to this day, thinking about where it all went wrong. I probably won't ever do it again.