Pixel art: What is it?
A pixel is the smallest building block of what a screen displays. Pixel art is the arrangement of these blocks on a pixel-by-pixel basis to make images and animations intended for screen display.

That sounds like a lot of time and work. Why does it exist?
It would probably have been ideal if games back in the day could all have been super smooth 3D graphics or hand-drawn cartoon lineart with hundreds of frames of animation, but computer memory was really limited then. This meant that the programming and the art had to be as optimized as possible.

Part of the allure of this art style, at least for some, is the challenge of working within the limitations that game makers faced when making the games we grew up with. The 8-bit NES system for instance had a series of restrictions: only 54 pixel colors to choose from with only 25 colors usable on screen at once (a background color, four sets of three tile colors and four sets of three sprite colors), with sprites at either 8x8 or 8x16 pixels, and a total screen resolution of 256x240 pixels.
If it was for old, limited technology, why is it still around today?

Because it's cool. Even though technology today allows for highly detailed, RAM-heavy 3D graphics on high-definition screens, with 8 or 16 bit graphics not seen nearly as much as it was in the 1980s and 90s, pixel art is still an established art medium with a huge variety of unique sub-styles.
Even though its role in pop culture is mostly nostalgia, pixel art is still in use today. It's the sharpest, most crisp art you can produce on a screen. It optimizes graphics for handhelds, it makes consistent animation easy, and it's even helpful for modern uses like readable icons for web pages or GUIs.
What makes it cool?
Because of the internet, pixel art from old videogames (like sprites, backgrounds and even animations) can be captured and translated exactly as it appeared in-game into .GIF and .PNG formats and spread around easily to fans.

"Ooh, look, this guy has Ibuki's crouching mid-punch animation on his site! I didn't have that in my collection..
*right click > save as*
..and now I do!"
Collecting game sprites from your favorite series can be like collecting baseball cards from your favorite teams. You can have a whole library of sprites and animations on your hard drive that take up very little space.
If you're the artistic type, pixel art is very accessible and easy to get into. All you need is a simple image editor like MS Paint. Working with pixels is like playing with digital Legos. Every pixel is a detail that you have full control over, and can undo and change easily at any time. You can even work over professional sprites and edit them around into something new — like turning a Megaman X sprite into an AstroBoy sprite — with very little work.

EASY TO MODIFY: "Well I'm glad King was in 'Capcom vs SNK', but I really wish they put Foxy in too. Hmm.."
And for as small as pixels are, there are countless styles you can work in: overhead RPGs like Chrono Trigger, more realistic Street Fighter, cartoony Super Mario World.. practically every game made had its own style. You can even make your own.
As hobbyists spend more time working with pixels, they find the process relaxing and the results rewarding. It's like how people spend time knitting because the process itself is soothing and the end result is just secondary.
How and where is it being used today, and where will it be in the future?

"What's this, a 3D game made with pixel art? How is this happening!?"
Pixel art is so basic an art style that it's very adaptable. Not just to be found on computer screens anymore, pixel art is such a part of culture that it shows up in stitching, wall decorations, bathroom tiles, and even as skins on 3D meshes.
But in the end, pixels belong to the display screen, and as long as there are indie game makers who need to work within certain limitations, or gamers who enjoy the old classics, or programers who like to dissect and modify games with MUGEN or other custom game engines, or artists who have an interest in this simple and very unique art style, then the pixel-pushing will carry on, the fans will pass it along, and 2D will indeed never die.