Help me pick out a Video Card for my son's gaming PC

Long story short, we built a gaming PC back in 2019 for Christmas and everything came out fine. Used PC Part Picker to make sure all parts were compatible and am using that build to check on upgrading the video card.

Thing is, I have no idea what is considered an "upgrade" here.

The card currently installed is:

Nvidia Geforce RTX 2060 Super Founders Edition Graphics Card

LINK

I guess it's not running as fast as he wants or whatever, so that's why the request for an upgrade. Looking in the same price range as that one I see this:

ASUS Dual GeForce® RTX 4070 OC Edition 12GB GDDR6X

LINK

I've already stuck it into his build at PC Part Picket and it says it's compatible...but is it an upgrade? I'm assuming given it's 5 years more advanced it is, but I don't honestly know what I'm looking at.

And just an FYI, here are a few of the other specs in the build if this helps:

- AMD Ryzen 7 2700 3.2 GHz 8-Core Processor

- MSI B450 TOMAHAWK MAX ATX AM4 Motherboard

- G.Skill Trident Z RGB 32 GB (2 x 16 GB) DDR4-3200 CL16 Memory

Was thinking about adding a addition pair of memory cards as well, but again...I have no clue if that'll do anything.

All help is most appreciated!