Yes, due to loss of traction or excessive cornering speed. But those are both issues inherent to two-wheeled vehicles, and adding gyroscopes won't solve either.
So you gain the ability to ride in the rain without wearing rain gear, but you give up cargo space and visibility. Not to mention the fact that your head will now be in the perfect position to get rammed by a bumper, and the lower profile increases the likelihood that other drivers won't see you.
It's a nifty trick, but I don't see who this would appeal to. Most motorcyclists already have rain-proof gear, and non-motorcyclists will still think it's a death trap.