I feel like the popularity of superhero narratives isn't because people particularly love those stories; it's because they're easy to make them decent. The public just wants good, enjoyable stories. The creators figured out that superhero stories are pretty reproducibly effective, so they keep making them.