JEB
Legend
@ilgatto: Decided to do some more monster research, based on the ones you raised!
Spitting snake/spitting cobra
You already laid out the differences between the Basic spitting cobra and 1e giant spitting snake (thanks for that!). I tried to see if 1e had any non-giant spitting snakes, but I don't see one - the "giant" flavor is it for that edition. Likewise, Basic has no distinct giant spitting cobra. As far as those versions of the game are concerned, the ones we have are just how you stat a spitting snake.
As noted, in 2e - despite using the 1e giant spitting snake stats - they no longer categorize the spitting snake as "giant" (the overall entry is just "snake" in both MC Vol. 1 and the Monstrous Manual). In my view, that means the 2e version is the successor of the two versions, at least as of the Monstrous Manual (which postdates the Rules Cyclopedia by two years).
I then looked further ahead, and confirmed that in 4e, the spitting cobra made a comeback, first in Dungeon and then in Monster Vault. Again, no distinction between normal and giant versions, just one spitting snake. (I'm not aware of any spitting snakes in 3e or 5e.)
So for the purposes of the spreadsheet, I'm going to continue treating it as all one monster. But I certainly don't begrudge you seeing it differently!
Killer bee/giant bee
In Basic, the 1983 "bee, giant" is statistically identical to the 1981 "killer bee". The descriptions are not 100% identical, but they're extremely similar and contain basically the same information. Furthermore, the Rules Cyclopedia outright says: Giant bees, also called "killer bees"... And again, the description is very similar. So I feel pretty confident that they're all the same.
As for the AD&D giant bees (worker honeybee, soldier honeybee), the stats are actually more similar than you'd think. The AD&D versions have more HD, but they have the same attack types and damage. In addition, they share similar lore about their royal jelly being useful for healing potions. So even more so than the spitting snake, I feel confident that these are meant to be the same creature, just interpreted differently in different lines. This is further solidified by the 3e "giant bee" still having similar stats to the AD&D version (and similar damage to both previous versions).
Having reviewed the above, though, I will make one change to my spreadsheet - I don't see any reason now not to consolidate the worker and soldier variants under a general "bee, giant" listing. OTOH, I do see the giant bumblebee as a bit different from the regular giant bee, and am happy to keep it separate.
Driver ant/giant ant
Similar to the giant bee, the 1983 Basic "ant, giant" is statistically identical to the 1981 Basic "driver ant", with nearly identical descriptions. The Rules Cyclopedia expands on the giant ant description, but it's still pretty much the same.
The 1e Monster Manual's giant ant does have different statistics, but it seems pretty clearly the same concept. (Though this is another case where you wonder why Basic didn't just clone those stats, since the "driver ant" postdates the 1e MM by four years.) And that giant ant is the one that carried on through 2e, 3e, and 4e (but not 5e, weirdly).
As for comparisons to the real-world driver ant... as @Paul Farquhar indicated, I wouldn't read too much into the name. It could just be that they thought "driver ant" sounded cooler in 1981. Now, it's possible their 1981 behavior was inspired by the siafu, but the expanded details in the Rules Cyclopedia make them sound more like generic pop-culture giant ants; so even if they started that way, they evolved away from it over the edition.
Shadow
Now, this one is really interesting. You are absolutely correct: 0e played it coy ("not 'undead' per se"), which Basic and AD&D interpreted very differently. Basic took it to mean "definitely not undead" while AD&D just figured "close enough, they must be undead". The AD&D interpretation eventually won out (and to be fair, it does have Gygax's stamp of approval).
However, things took a swerve in 4e, which made them not undead again - instead, they were humanoids with the shadow origin. (5e reverted this, of course.)
Due to this mixed history, it seems fair to just go with one shadow - especially since the rest of the details don't shift that radically between versions. The alternative is splitting it into somewhere between four to six versions...
Spitting snake/spitting cobra
You already laid out the differences between the Basic spitting cobra and 1e giant spitting snake (thanks for that!). I tried to see if 1e had any non-giant spitting snakes, but I don't see one - the "giant" flavor is it for that edition. Likewise, Basic has no distinct giant spitting cobra. As far as those versions of the game are concerned, the ones we have are just how you stat a spitting snake.
As noted, in 2e - despite using the 1e giant spitting snake stats - they no longer categorize the spitting snake as "giant" (the overall entry is just "snake" in both MC Vol. 1 and the Monstrous Manual). In my view, that means the 2e version is the successor of the two versions, at least as of the Monstrous Manual (which postdates the Rules Cyclopedia by two years).
I then looked further ahead, and confirmed that in 4e, the spitting cobra made a comeback, first in Dungeon and then in Monster Vault. Again, no distinction between normal and giant versions, just one spitting snake. (I'm not aware of any spitting snakes in 3e or 5e.)
So for the purposes of the spreadsheet, I'm going to continue treating it as all one monster. But I certainly don't begrudge you seeing it differently!
Killer bee/giant bee
In Basic, the 1983 "bee, giant" is statistically identical to the 1981 "killer bee". The descriptions are not 100% identical, but they're extremely similar and contain basically the same information. Furthermore, the Rules Cyclopedia outright says: Giant bees, also called "killer bees"... And again, the description is very similar. So I feel pretty confident that they're all the same.
As for the AD&D giant bees (worker honeybee, soldier honeybee), the stats are actually more similar than you'd think. The AD&D versions have more HD, but they have the same attack types and damage. In addition, they share similar lore about their royal jelly being useful for healing potions. So even more so than the spitting snake, I feel confident that these are meant to be the same creature, just interpreted differently in different lines. This is further solidified by the 3e "giant bee" still having similar stats to the AD&D version (and similar damage to both previous versions).
Having reviewed the above, though, I will make one change to my spreadsheet - I don't see any reason now not to consolidate the worker and soldier variants under a general "bee, giant" listing. OTOH, I do see the giant bumblebee as a bit different from the regular giant bee, and am happy to keep it separate.
Driver ant/giant ant
Similar to the giant bee, the 1983 Basic "ant, giant" is statistically identical to the 1981 Basic "driver ant", with nearly identical descriptions. The Rules Cyclopedia expands on the giant ant description, but it's still pretty much the same.
The 1e Monster Manual's giant ant does have different statistics, but it seems pretty clearly the same concept. (Though this is another case where you wonder why Basic didn't just clone those stats, since the "driver ant" postdates the 1e MM by four years.) And that giant ant is the one that carried on through 2e, 3e, and 4e (but not 5e, weirdly).
As for comparisons to the real-world driver ant... as @Paul Farquhar indicated, I wouldn't read too much into the name. It could just be that they thought "driver ant" sounded cooler in 1981. Now, it's possible their 1981 behavior was inspired by the siafu, but the expanded details in the Rules Cyclopedia make them sound more like generic pop-culture giant ants; so even if they started that way, they evolved away from it over the edition.
Shadow
Now, this one is really interesting. You are absolutely correct: 0e played it coy ("not 'undead' per se"), which Basic and AD&D interpreted very differently. Basic took it to mean "definitely not undead" while AD&D just figured "close enough, they must be undead". The AD&D interpretation eventually won out (and to be fair, it does have Gygax's stamp of approval).
However, things took a swerve in 4e, which made them not undead again - instead, they were humanoids with the shadow origin. (5e reverted this, of course.)
Due to this mixed history, it seems fair to just go with one shadow - especially since the rest of the details don't shift that radically between versions. The alternative is splitting it into somewhere between four to six versions...