Just play the long game, which is focusing on getting good at your job to develop your own competency. In the long term, competency will help you get ahead.
Being popular at work is one of the competencies though, so you need to figure that one out too. Branch out and improve your social skills.
People are capable of rallying around someone who’s reliable. Reliability in work becomes a big part of likability, actually. And if that’s not the case, you can nudge the culture it in that direction by thanking people for delivering what they promised to you when they promised to do it.
Basically, when personal status and competency at the job are out of sync, that’s an unhealthy state for the workplace. You can (to a degree) fix your own problem and the workplace’s problem at the same time, by just using your own voice to acknowledge and appreciate when people do their jobs well.
It’s a good feeling to go after a team as a goal, and doing the job well is a co-op aspect of the workplace. It’s like bros at the gym: each person might be working on their own thing, but they share an interest in getting better. Even if the company doesn’t have any other inspiring direction, the direction you can share with your coworkers can be “doing this in an excellent way”.
So all of this boils down to a couple simple things, and the game works at many levels. It works immediately and long term, and for yourself and everyone else:
Decide that your reason for doing the job well is primarily that it feels better than doing it poorly. Train yourself to do the job well for the pleasure of a job well done.
Speak up and recognize others when they do their jobs well.