Sometimes people don’t want advice, they just want to vent and feel their feelings. Giving advice when they are upset doesn’t help. Instead maybe wait a couple hours and then ask if he wants to talk about it. Or say that you understand why he feels that he’s useless but remind him that he is loved and has many skills etc. I don’t think you are the asshole, you want to help, but maybe that wasn’t the right time.