Aquaman was fun and not like the others, was the major piece of the holiday in which Venom was the last big PG-13 action tentpole. Aquaman was also liked beforehand iirc. It's like asking why did No Way Home or more likely Guardians 3 do well after Eternals and Quantumania.
The non-JL heroes struggled imho because of lack of trust (though Max did a number on it, look at the drop from SS to TSS) and/or bad marketing (Shazam is one of my favorite recent CBMs but this looked awful (also for some reason 95% of WB family aiming films end up underperforming (most of WAG library, Shazam, Pikachu, etc)).