I wasn't able to fire the All-Clear Pipe even though I cleared all the cups.

If the app closed before the tour's ending movie, you can watch it by replaying a course during the tour's active period.
After that, try to fire the All-Clear Pipe again.