It can affect any wallet as long as the victim used his wallet to connect to the fake website. You can see the link posted by the OP, it is a fake site that someone can connect his wallet to and the wallet will be compromised.
True, but with hardware wallet at least you have to press physical button and confirm transaction, meaning chances are that he would (probably) realize that someone is trying to take his money.
You are senior member in the forum and should know that connecting your wallet, where you have this amount of money, to airdrop site is not safe.
This can happen to anyone, no matter the forum rank and/or experience, all it takes is not being focused at what you are doing atm. I know a guy who is in crypto for many years and living solely out of it since 2013 and few years ago he managed to lose $100k in a similar manner (he was in a rush and wanted to buy some shitcoin, went to a phishing site thanks to Google offering it as a first result, connected his Metamask and lost everything on it).
Maybe some other forum members who have the technical skill can assist. Sorry for your loss.
No one can help him get his money back, he may online get PM for scammers claiming that they can get his money back.