Making a rigidbody "immune" to reacting with another specific rigidbody?

I had some trouble with phrasing this question in an understandable way, so instead I'll just explain what it is I'm trying to do and what my problem is:

I'm trying to simulate a controllable space ship where players can also move around inside. If you've ever seen gameplay of sea of thieves or maybe played Valheim and went out on a boat, its pretty much that.

However, I'm having trouble figuring out how to achieve this by using the unity physics engine, which i wanna use because i think its best suited for simulating things like thrusters and general movement without having to dive deep into interpolation-math and stuff like that.

My current problem is that, whenever the player spawns inside of the space ship, it gets pushed down, as the players weight/force is applied to it in a no-gravity environment. I tried to make the ships rigidbody kinematic, but that would prevent me from using forces for the movement.

Any suggestions? :C