I make all my own clothes now - I haven't bought a thing in over 2 years! I started from being not a total beginner, but certainly not an expert.
I'd really recommend doing some form of workshop to start with. Lots of sewing shops will do a beginner-style session (usually making a basic skirt or a top). It will just help you work out one end of a sewing machine from the other, and will probably help with troubleshooting too (and cover a lot of the standard terminology).
I highly recommend Tilly and The Buttons as a first port of call. Her patterns are very beginner friendly, and come with lots of photos alongside the instructions, and are very step-by-step. Some of the more traditional pattern companies assume a level of knowledge/understanding, and often roll a couple of steps into the same instruction, which can be confusing.
Tilly's first book (I think it's called Love at First Stitch) might be a good place to start. Or Make It Simple. I've made everything in the latter (some of them several times over!) and it's all very wearable. Her standalone patterns are all good too - the Lotta dress is very easy, as are some of the others, but their names escape me as I know they're not styles that suit my shape).
Instagram is definitely a brilliant resource. Find a pattern you're interested in and then search for it there. You'll find real people of all shapes and sizes showing off their creations, and you can learn a lot about the way something looks on real people. And most people will pass comment on the pattern too, so you can see if there likely to be challenges or problems with it.
It's the most rewarding hobby - I was wearing a lovely dress I'd made in a nice independent boutique (was with a friend, not shopping for me!) and the owner commented and asked me where I'd bought it. She couldn't believe it when I said I'd made it, and it made me feel amazing (which I already did, just by wearing my lovely dress that I'm proud of!).