Public support for Stormont politics has reached a new low following the collapse of talks to restore the North’s local power-sharing institutions.