Sorry to hear that the collections are missing in your Lightroom. Thanks for reaching out. We're here to help.
Which version of the application and macOS are you using? Can you try signing out and signing back in once? Have you tried reinstalling the application after the payment got canceled? Were the collections synced?