Ride the Shoopuf's last ability doesn't have a duration. Once it resolves, it will remain in effect until the game ends, Ride the Shoopuf's leaves the battlefield, or some subsequent effect changes its characteristics, whichever comes first.

If Ride the Shoopuf becomes a creature but you haven't controlled it continuously since your most recent turn began, you won't be able to attack with it that turn.