I'm not surprised at all. This is exactly what happened 8 years ago (Far Cry 3 for example), AND 7th gen consoles, when launched, were at the cutting edge of what was possible. Both X1 and PS4 were released with already anaemic hardware.
Something not mentioned too much. Not only are the base systems already 7 years old, there was a wealth of evidence early on they were built on a budget and would struggle to last. Didn't stop people buying them in droves.
We didn't start seeing the first Cyberpunk gameplay trailers until fairly late in the gen, and it should've been apparent those base systems would struggle to run it anywhere close to it's intended quality.