I only mentioned sand attack for troublesome match ups. Sand attack can help when you don't have a level or type advantage (and not just for pidgey, it can make switching in another pokemon easier).
Yeah ok there are other pokemon better than pidgey that are available at the same time, but then if the tier list is considering comparisons to other pokemon then in RB bulbasaur is top tier and everything else is low. Soloing the game with saur is the most efficient way to run through the game, and stopping to do anything else other than catch HM slaves is comprimising efficiency.
That would also make nidoqueen one of the least efficient pokemon in the game. Queen is outclassed by king, and has the same availability, so there would be no reason to use queen at all. There's no species clause either, so if you wanted more than one nido, you can just catch more kings. In reality queen is a good pokemon, but when you're comparing its efficiency with other options, it is made completely redundant, which drastically alters its position on the tier list.