Is E3 an abnormal note for a soprano?

with training, many sopranos can hit that note. Not many can use it outside the studio since it is an extreme low note. Those that can are perhaps the exception to the rule. In standard chorus or opera literature, no soprano needs to sing that low. A mezzo or an alto, rarely.