If anything, the clips at the Sci-Fi might be regarded by some as mildly funny. I think they could be described as what many people refer to as "camp." They are the types of clips that used to be fodder for the Mystery Science Theater crowd (for any of you that remember that show). They are fun to watch... As others have noted, the atmosphere definitely trumps the food!
If there is anything that might even be remotely intimidating to a young child, it is the reduced light level. (It is supposed to be like being at a drive-in movie at night, so it is a bit dim.) However, it is far from "dark", and there are lights on the "cars" so that you can see the menus (with effort) and your food.