Are discarded upgrade cards (like external racks) counted towards endgame scoring when they were on a ship that was destroyed (after the ship had used and discarded it)?

Yes.

"Scoring" in the RRG, 1st (and 2nd) bullet points.