Does this connector exist and if so what is the correct name?
In my almost 40 years of tearing apart electronics, I have only seen what you are specifically asking for once or twice in the SIP form-factor, and each time it was a custom OEM part that wasn't available on the open market.

Although they are rarely seen these days, 90 degree DIP sockets were at one time popular back when discreet non-multiplexed LED display modules were common.  They still appear to be available, at least to some limited degree:





So, I guess the proper term would be "8 pin 90 degree vertical SIP socket", but like I said, such a thing does not exist on the open market as far as I can tell.