It has never been a respected profession. Homicide has always been an occupational hazard.

GTA3 (1999/2000?) put it into the popular consciousness by allowing players to emulate it, but IME nobody really started getting shamed for joking about it until around 2010 (coincidental to trans issues becoming mainstream?).