Irreducible bimodules over alternative algebras and superalgebras