Is the Cyberpunk 2077 community willing to hold on, if CDPR were to pull off this major overhaul?
They held on for No Man's Sky.
They held on for Final Fantasy 14, which was a far more riskier bet since it's an MMO.
This being a single player game, it's mostly irrelevant whether people "hold on". If they bring the game to their original vision, it'll be big enough news to bring back anyone who left AND sell them expansions later down the road.
Let's not forget we're talking about gamers here. The want to play the game will trump their outrage, as has been proven time and time again.