Transparent pipes in material preview

You dont need to delete faces, you can set different material for the ones you need to have transparent:


It’s good to watch some tutorials, not everything is as it seems in Blender