First, yes , Big Dipper is both a name (perhaps old fashioned) for a roller coaster, and also a colloquial name for Ursa Major (American english, I think).
It's use in the lyrics you quoted is...