The CPU runs the games engine. The games engine makes calls to whatever compatible graphics API's it's been coded to use (so DirectX, Vulkan, OpenGl, etc).
The CPU makes a draw call against whatever API. "Yo, GPU/DirectX12, take <this> scene and render it in your current graphics settings" (which is 1 "frame" of your "fps"). From this point ALL the work is on the GPU and is controlled by whatever graphics setting/res/etc you use.
So a FAST CPU can make MANY of these API calls, easily. It's a(n almost) static workload on the games engine. A SLOW CPU starts to struggle making these API calls fast enough.
A FAST GPU can handle these calls with high levels of detail/resolution easily. A SLOW GPU struggles with higher quality graphics settings as it has more work to do.
So (to make the best use of CPU and GPU)....
FAST CPU and FAST GPU = Many frames per second at high detail. E.G 5800X + 3090 will (generally) give HIGH frame rate 4K and should still be pushing 100/120hz @ 4k.
FAST CPU and SLOW GPU = Many frames per second at low detail. E.G 5800X + 1070ti will (generally) give MANY frames of 1080p quickly and is good for high hz 1080p
SLOW CPU and FAST GPU = Lower frame rate but the graphics card can handle way more detail per frame. E.G 1600X + 3090 will give.... "ok" frames at high detail e.g. 4K+max detail 60hz
SLOW CPU and SLOW GPU = Lower frame rate and lower detail. E.G 1600X + 1070ti will give moderate frame @ moderate detail, probably decent 1440p
All this is just relative. I'm not suggesting a 1600X + 1070ti can't do awesome work. Just VS alternatives and to give an idea.
If the GPU is high performance, it's able to deal with "easier" draw calls quickly so you get a CPU that's maxed out trying to push work (draw calls) to the GPU that it completes with ease and is constantly sat waiting for CPU. You'll see GPU usage is <100% (usually 50-80) and CPU is maxed out. At this point, you should improve CPU or increase detail/res.
If the CPU is high performance, it's able to push MANY draw calls to the GPU that the GPU then needs to handle quickly (which becomes frame rate/fps). If it's not able to, due to higher visual quality settings being configured, you see the GPU maxed out trying to render frames and the CPU is <100% used. At the point, you should improve GPU or reduce detail/res.
In pretty much all cases, MSI afterburner can be set up to show you the GPU usage and the usage (and usage per core) of CPU. Use the last 2 lines above to tune your rig to make the most of your available kit.
Take this understanding with Zefans suggestion about scaling. MSI afterburner will show current levels... check power/usage of current CPU/GPU, compare with CPU/GPU you want to move to. You should be able to work out if either will be restricted by the other.