I'll join the chorus recommending Godot. A lot lighter than Unity or Unreal, it's open source, well documented and quite capable. It's got a lot of features, in a lot of ways it isn't "dead simple."
I might recommend starting off using Python's Pygame library. Do something like create Flappy Bird in it, that will give you a pretty good idea of how a video game works under the hood, and it'll run on a potato.
For pixel art you might go with LibreSprite or Pixelorama. These will allow you to create tile sets for backgrounds as well as character sprites.
If you're looking to get into 3D art, you've basically got to go with Blender.