In the US there is the 'Ghost Flower' or 'Indian Pipe' which is parasitic to fungus which is parasitic to the host tree. It is totally white with no chlorophyll.

It's parasites all the way down.

Whoa. It even looks mushroomy. It's like a Last of Us orchid. That's wild.

There are lots of species of plants that don't directly rely on photosynthesis. Many are essentially sub-terrestrial parasites, getting their "food" from fungi and sometimes even other plants. It's seemingly more common in orchids, in part because the family generally already has a strong reliance on fungi as part of their general reproductive strategy.

Huh, neat

A small add-on:

Usually, plants get most their nutrients from the soil, most importantly nitrogen (but also P, K and some others).

In some locations, such as swamps or very sandy soils, there is not a lot of nutrients for the plants to get and these "nutrient-poor" soils are usually those where carnivorous plants live. They simply get the nutrients from insects, which consist of yummy proteins made of nitrogen.

So basically one should not really wonder why carnivorous plants need sunlight, is has not much to do with mineral nutrients in the soil. Plants do photosynthesis by taking up CO2 from the air and using energy from the sunlight in order to produce C6H12O6, Glucose. And I guess this is also what the japanese orchid steals from the fungi - sugar.

Of course these processes do not work completely independent from each other. But Glucose, the product of photosynthesis, is not really considered a nutrient, that would be carbon.