No definately not. SOunds like the seal is broken or the window has dropped a fraction. Take off the cover on a very hot day and then refit it & wind the window down and up. The heat will stretch the cover slightly (Assuming its not the hard top and may help with the problem.)
You would also be advised to clean the seal above the window, sometimes some grit can cause a water ingress.
didnt manage to get the roof off couldnt see how it was done and didnt want to damage it by pulling it apart. had a good look when the water comes in and noticed its not from the rubber its from the metal above it where it folds when the roof closes. its strange cause cant see how its getting in. might take it to honda and let them have a look.