Were women favored and honored more than prophets and companions by the mention of two women in Surat At-Tahrim as an example for believers, or is there another wisdom behind mentioning them by name?

The specific mention of women in the example given in Surat At-Tahrim for believers does not imply their superiority over men, prophets, or companions. The reason for their specific mention is due to the context of the Surah (definition), which deals with the matter of the Prophet's wives, peace be upon him. It aims to warn them against conspiring against him and to clarify that their connection to him, peace be upon him, will not benefit them if they do not obey Allah and His Messenger, just as the connection of the wives of Nuh and Lut to them did not benefit them.