Sisters... from what I've seen, they tend to worry waaaay too much about whether they would make good wives, good mothers, etc... in they end, some even conclude that nobody should marry them because they're that bad lol

I reckon you should stop worrying too much, trust Allah and take refuge in Allah from shaytan, cos that's where most of these thoughts/worries are coming from.

You could also continue to pray Istikarah salah over the issue, until you feel more confident.

May Allah grant you a blissful married life, ameen.