Pyramids are said to have one of three orientations:
An upright piece has its square base parallel to the playing surface, pointing away from the playing surface.
A weird piece is any piece which is neither flat nor upright. Barring psychokinesis or some kind of vortex, a piece needs the help of another piece to be weird.
Note that a piece's orientation has nothing to do with whether or not the piece is grounded.