You can play a ton of songs with like 5-6 open chords. Find a song you don't hate that just uses G, C, and D majors, and drill the hell out of it until it's easy to transition between those. Way more fun to practice with a real song. You may pick up A-minor or something on the bridge of that song, which is nice. Pick up open A and E majors and E minor on top of that base and you can play rhythm on like 50+% of all guitar-heavy popular music ever written without going any farther. Then start working on barre and (relatedly) power chords and you'll get that number up to 90%. Wait to do that because barre chords require different hand muscles than open chords, so you'll hit trouble again when you start on them and no sense in tackling all that difficulty at the same time.

Take heart: once you get over the initial how-the-hell-can-my-fingers-even-do-that hump, learning enough guitar that it's pleasant to listen to is quick. You can hit that mark with casual practice inside 3 months, easily. By contrast, I spent years playing Alto Sax and got way (way) better at it than I ever was at guitar, but that was never pleasant to listen to solo—most instruments you've got to be really really good at them before they're tolerable solo, but guitar's about as far the other direction as you can get.