I'd love to see more posts like this on HN. You generally learn far more from what didn't work for others than you do from the many survivorship biased stories that usually get posted.
Curious what questions you think you could have asked in your up-front interviews to uncover the issues prior to building?