Australians are facing some of the bleakest consumer sentiment in decades, leaving households increasingly pessimistic about what comes next.