That doesn't sound like it's your fault!
It's really strange the first time you experience it.
But you can't go wrong with talking to users to understand the problems they are dealing with
https://www.amazon.com/Mom-Test-customers-business-everyone/...
The whole book is basically how to get useful information by being curious about the potential customer, how to decode “That’s great” by asking for commitments/intros/money, and also a bit about how to know whether you’re talking to the right person in the first place.
Sometimes you just don’t see it, and that’s ok. Not everything is “I would have succeeded if only…”
A year later the entire project was wound down. It had never shipped past an extremely limited beta. It completely failed to generate any sort of traction or product market fit. The manager who brushed off my concerns left the team way before this and went to work on something else in the organization.
I had a similar feeling about a project once. I thought "Boy is this stupid. No one in their right mind is going to pay for this. Why are we building this." Let me manager know my feelings. Stayed and built it.
Thing is a huge success. One of our best selling products. Boy do I still feel dumb. Very humbling, honestly. Shows what little I actually know about what people want.