North Korea is in such poor shape that they probably can't maintain much of the equipment much less keep the personnel trained and ready to use it effectively. Not a reason to go to war, but the threat to Soul and SK in general is likely massively overstated.
I think the strategic rational for unification completely swapped about 20 years ago. Up until the early 2000s it was likely in South Korea's, and the US's, interest to find a way to topple NK and unify the peninsula. The two populations had blood ties and common culture. Technologically the gap was growing but still reasonable. It would have been close to an east/west Germany type of situation where unification took effort but ultimately was clearly beneficial. China (and Russia) would have been losers in that unification would have brought a western friendly government even closer to their border. Additionally, NK still had a chance of re-energizing and becoming a real threat to SK.
Now however NK is in such bad shape that unification would be traumatic. South Korea would take on a problem of epic proportions, caring for and bringing a population of that size back into the broader world would be exceptionally costly and definitely not guaranteed to end well, possibly destabilizing SK in the process. Their cultures have grown apart making it hard for them to understand each other. The blood ties are not really there anymore. China and Russia would likely be the winners in that everyone sees NK as crazy and anyone helping them is hurting the world so they could get rid of that baggage. China especially would gain by having rail access to massive shipping assets to deliver goods even cheaper to the world. Finally, the US would loose a major rationale for stationing forces that close to China. They could, rightfully, say that NK isn't a threat and the massive US assets in South Korea and Japan should be drawn down.
The only way unification can ever happen will be with Chinese blessing, with or without democracy. That would mean a full exit of US forces from the peninsula, and substantial pandering to the CCP and influence in Seoul. Which isn't that far off a thought honestly - for the most part, Korea was a tributary of China. With rapidly changing demographics and economic heft in both countries, it's even more likely SK will gravitate towards China, to the point that the Chinese will find more persuasion in unification and predictability.
[dead]
> North Korea is in such poor shape that they probably can't maintain much of the equipment
Sadly we know from events in Ukraine that NK artillery works and that they have plenty of it. Yes, it's poor quality, but far from harmless.
Also to be clear: artillery is not exactly rocket science. They idea that NK doesn't have huge stockpiles is ludicrous.