Went to Legoland yesterday and oof, that new Pirate ride is brutal. The dispatches are very slow and infrequent, making for what was easily the longest wait of the day. Definitely something that you need to get on early when the park opens.
As for the ride itself, it's fine if you look at it as simply a modernizing of the Cypress Gardens canals. As an adult, it's best to just enjoy it as a relaxing tour. For kids, the Pirates theme is very scattered and is probably only there to try and keep their attention through what would otherwise be a boring 20 minutes compared to the rest of the park. The only fun part I had was the end where the boat drives through the lake to return to the station and you come across some choppy water.