my 5 yr old son said it was scary, but he liked it. I feel they did a good job at making it scary enough for young children, but not too tense or frightening.
This is why a lot of adults probably do not like the attraction especially if they did Alien. It is a child-friendly attraction they were trying to make.