It’s not your fault the video you linked uses that sensationalist title (unless you are Mr./Ms. Fireship themselves) but yeah, it’s click baity. Soft bricking is something just breaking. The term brick was meant as a harsher version of that. This title aims to grab you with a concept that is far worse than software errors when it was software errors.

I have spent my time wisely typing this internet comment.

A brick is a brick. It can be used to make a wall or hold paper down. That brick will never "wake up" and become more than a brick. A brick is not soft. A brick is not temporary. If you have a brick, it does not and will not ever work for anything except masonry.

The word "literally" has real meaning and so does the concept of a "brick" in electronics. These things are immutable. Do not change the meaning of "immutable".

Soft brick is a software brick, hard brick is a hardware brick.

it is a sql query