BE is an auxiliary verb when used with other verb forms to construct a progressive or passive form. In most schools of grammar, when BE used alone (except in short answers, question tags, etc), then it is not an auxiliary verb.
He is in the street can be analysed in exactly the same way as He sits in the street.