Not quite a tarp, but I've camped with a heavy wet snow storm using my tube tent. Normally the ends of a tube tent are open, but I was able to close off one end and orient the other to avoid too much snow coming in. Overall, I was cozy through the night. Also some nights of rain. This was spring hiking in desert areas of Utah so fairly dry air overall despite the spring storms coming through. The desert air also meant than on average condensation isn't as big of an issue as normally wetter areas. It has also meant bugs were not as often an issue.
Overall, if I am in an area of extended wet rain periods, I would still prefer my tent and have waited out a rainy day or two in the tent when otherwise the mud on gravel road would be difficult. However, for dealing with more occasional and unexpected and sometimes even severe weather, I've found the tube tent to be ok.