Six Lives at the National Portrait Gallery shows Henry VIII’s wives lost the battle for a legacy