Hello fellow Michigander, More of a novelty than anything else. No reservation needed. Never a line but keep in mind it only holds around 25-30 people max.
There is usually a paper nearby which lists the times that it runs. You can stay on as long as you like.
I think it's every 15 minutes it goes up, stays for 15 minutes then returns to deck 5.