The CPU is definitely a limitation for Switch 2, but I think we've seen the results of that. Games that target 60fps on other platforms tend to target 30-40fps on Switch 2.
The most CPU-intensive titles tend to be simulation games. Modern versions of those (that didn't release on 8th Gen consoles) might struggle without significant compromises, like SW1 with Cities Skylines, as an example. AAA, cinematic titles, comparatively aren't very CPU intensive and where they are you can typically make cutbacks without most people noticing.
Plus, I expect Nintendo to free up CPU resources over-time. We already know one of the cores might free up as they optimize their OS, and we also know that the max theoretical clock is much higher than its current capped boost. Combined those probably could boost effective CPU performance +10-15% when needed.
