Jun didn't die, nobody knows what happens to him. Kat was indeed useless, she ran around with a sidearm. Everyone had B.A deaths but Carter's was among the most noble.
I know jun didn't die. He went on to recruit some of the spartan 4's. Jorge might not be dead, a few people think he's still alive on the part of the ship that got launched somewhere else