I’m not sure if you’ve already done this, but my first suggestion is …
practice, practice, practice!!
Do you have some worsted weight yarn and size five (US) or above DNPs? Get some larger needles if you don’t have them, and just knit a tube. No fancy pattern, or anything. Basic cast on, not too many stitches (but not to little! It makes it hard to work), and knit knit knit knit.
Once you mastered basic DNP-work, start doing things that are incorperated into the sock, like the heel, and the toe, or if you’re doing a patterned sock, work that into your tube-o-practice
Once you’ve figured out HOW to do everything, why not get some thicker yarn you LOVE (either in colour or squoshyness), and make a pair of slipper socks out of that? That way you can finish it quickly enough not to loose interest, but still have something wearable (and hopefully you will love working with and fondling the yarn so much you will cast on for the second one instantly after casting off the first one!)
My second bit of advice is “Don’t panic”. Fairly simple, but important none the less!
I hope you learn to love the DNPs, and finish your first pair of socks! I was in a similar boat as you (the tiny yarn wasn’t working for me) and I’ve started a slipper-sock, so hopefully we can both become masters of the socks!