We do really well with maker names and part numbers. If you have an XLR interface, why don’t you use that for the microphone? I didn’t follow your connections.
If the interface has a TRS socket, that’s usually for a high volume connection such as a mixer or an instrument such as a guitar. I would not expect a microphone to do well plugged into that.
I don’t think you need special microphones, interfaces or connections. I think you need to get what you got connected properly. Many posters who complain about bad microphones are much happier correcting connection errors or recording in a quiet room.
If you think what you have is correct, do the newspaper test. Start recording and crunch up a newspaper in front of the microphone. Reduce the volume until the crunching doesn’t overload.
Then Analyse > Plot Spectrum.
Ignore the peak at 10Hz. That’s not sound. All the sounds are within about 8dB across the audible range, 20Hz to about 15KHz.
Koz