It's definitely a consideration. We honestly have no idea yet what it will entail. Devs actually had more motivation to optimize for mulitthreaded gaming for the 8th gen with 8 horrible Jaguar Cores between 1.6 to 2.3Ghz depending on model. Gen9 consoles will still have 8 Cores, but far far stronger. The thing that makes me not overly worried about CPU demands dramatically increasing is the balance with 10-12TF GPU and focus on 4K gaming, probably a mix of 30fps and 60fps for console gaming.
The thing about a 3300X, or a 3600, or a 10600K is that you're not stuck with it, you have upgrade paths should things get tough in a couple of years. If someone has a budget of say $1k, it could save them a considerable amount of money to put towards a better GPU, larger SSD, etc, which will pay off more today. Eg; a 3300X w/2070S and 1TB SSD would be better balanced than a 3800XT or 10700K w/1660S and 512GB SSD, but be similar in price (even down to the 3300x coming with a very workable stock HSF, and the K and XT CPUs come with no HSF at all).
It all comes down to budget and understanding what is likely to be necessary to upgrade first, priorities on resolution and favored titles/genres, etc.