I took my son to the Apex fall games last year as a 2030 5th grader and we both had a ton of fun.

If you're concerned about the value of the exposure for your 5th grader, I doubt it's a huge return on your $800 investment, but it was a blast and the coaches are current pro players who were a lot of fun for the kids to play with. It's not really a cut throat competitive vibe at all, it's more of a really fun weekend to spend with your kid with a lot of good players.