Setting the colour space in the camera settings to sRGB will only apply to JPEG or TIFF files produced by the camera.
An imported raw file will have no colour space applied to it.
The colour profile will need to be specified when you export the image from Photoshop. There are two tick boxes in the "export-as" dialogue box :
1. Convert to sRGB
2. Embed colour profile.
Both these need to be ticked or you will not be converting the image to sRGB colour space or embedding the profile.