Tip: to quickly assign the red material to all parts of the ship in one go, you can select all of the MeshInstance3D parts, expand the Geometry menu in the Inspector and drag the ship_red_material.tres from FileSystem directly into the MaterialOverride slot under Geometry
Note: tested in Godot v4.2.2