Welcome! Glad you decided to join us, I was a lurker for a long time too.

In my experience, pixel art is a niche skill in relatively high demand for indie games and Let’s Players. Sometimes higher profile clients (ex. Adult Swim) hire for TV or music videos. The job board on here is active, usually with new offers every 1-3 days, and the community on Twitter is active and decently sized. You should post your portfolio and/or contact some of those prospective clients.
In terms of ease in making basic income, I’d say it depends on your cost of living. Freelancers must charge more hourly than employees because they don’t get benefits and taxes are higher (at least in the US). If you live in a place with high rent like NY or LA, you’ll probably have trouble unless you’re at the “top of the food chain”. I think people at this level tend to have other art/animation gigs or work in other fields concurrently, both to sustain themselves and because pixel art isn’t their main skill, just another medium they dabble in (while I don’t consider myself a top pixel artist, I am fairly experienced, and this is the case for me).
However, if you live in an area where cost of living is low, then it’s possible to sustain yourself just through commissions/contract work, Patreon, and/or asset sales (Itch.io store). You don’t have to be the most amazing pixel artist ever for this, you just need to be decent at asset creation (could be tilesets, animation, set pieces, character art, etc.). People tend to hire artists with nice-looking colors, nice sense of clusters, and good readability (you can easily tell what the artwork is depicting from a distance). There tend to be a lot of games in need for foliage, buildings, character animations, character portraits, tilesets for various biomes, weapons, inventory items, icons, vehicles, and the like, so if you are particularly good at some or all of these things, you have a good chance of finding work.
EDIT: There’s also a market for pixel art that’s not for games, but rather for icons on social media or just for fun, if you just want to take small commissions for a bit of disposable income or financial padding.