I have Windows 10 on automatic updates and update SONAR regularly. Imaging one's C: drive is a necessary part of using computers. The rollback option in SONAR works just fine, and imaging gets Windows back to where it was is there's some truly showstopping issue (which hasn't happened to me yet).
In my experience, any inconveniences associated with an update (Windows or SONAR) are outweighed by the advantages. I have yet to find a situation where reverting was more advantageous that just coping with/working around/ignoring any issue that arose.
The flip side is there are very valid reasons to "freeze" a system in a working state. You simply have to decide which tradeoff (known stability vs. potential improvements) is the one you want to make.
Zooming out, computers are machines and they need to be maintained. Maintenance time has to be factored into the music-making process, whether it's changing strings, tuning a piano, testing RAM, backing up, or updating software. Maintenance with computer-based recording is much less than the maintenance required with tape-based recording so at least we've improved in that respect.