Rainbow temporarily lifts spirit of crown that braved storm to stand at palace gates upon learning of queen's deteriorating health, but mood turns mournful after her death declared