In FAANG for typical SWEs it is rare for to outright get fired for a mistake. How you handle the mistake matters a lot though. Usually if things are less than perfect during performance reviews, you just don't get promoted.