You probably won't notice the ceiling when you're on the ride; lighting and movement should direct your attention elsewhere, if it's been designed competently. Certainly no worse than Cat, which only compels you to look "up" at one misguided moment.
I think this looks fantastic. Animatronics have real fur (unlike the "muppets" on the Singapore Sesame Street ride) and look adorable. The plot concerns "adoption day," where the pets are helping your puppy analogues prepare for adoption. Apparently the rockets figure in as some sort of improvised shortcut that goes awry... which leads to the dreaded bath time. Writers from Illumination penned the script, so I have high hopes this is closer to Minion Mayhem than Fast & Furious.