His Majesty King Charles III's Balmoral estate in Scotland has experienced a shocking bridge collapse after being battered by extreme weather for weeks