I can get into the build-ups & the drama of those moments, but the thing for me is that 95% of the action is utterly irrelevant to the outcome of the game.
(Real) football even if you don't score, each play affects field position. Soccer, you don't score & the goalie can instantly boot it most of the way across the field & the whole attack was mostly pointless.
I think it's mainly popular because the rules are easy enough to be understood by 4 year olds & poor people all over the world can easily play it, so it's ingrained early.