Otherwise, to non-tech laypeople and average SWEs, I'd say anyone who is a SWE at Google or any FAANG(MULA+) are held in extremely high regard and awe.
It probably has lost a bit of its shine to be honest. But it's still exceptionally shiny if you compare it to what else is out there. Remember the overwhelming majority of SWEs are not employed at FAANG or other top tech companies. They're employed at places like Wells Fargo or Home Depot or Bank of America. These people would be jumping up and down ecstatic to be offered a chance to work at Google.
If there is one company that seems to have lost a lot of shine for a SWE career in the past few years, I'd say it's Amazon?