It does. But while in English you could easily say something like "you son of a bitch, you did it" to a friend, you wouldn't do the same with Hurensohn in German as this would offend most people.
Yeah, that's the ballpark of where "Hurensohn" is on the harshness scale. You can't say it admiringly either. So "oh, you son of a bitch, you did it!" isn't possible for "Hurensohn".