I used to chase tornadoes when I lived further north.

Been near several, and through two (one of which had not touched down yet - it went right over the top of me.)

You will hear it, unless you're in the middle of the hurricane and the entire house sounds like its going to come apart already, in which case loud is just loud (e.g. during Ivan last year, I doubt I would have heard a tornado before it got me, simply due to the lack of time to react from the time the sound was distinct from the hurricane's general noisefield to when the vortex got me.)

But in this case, where you're expecting tropical storm sustained winds, yes, you will hear it - provided it doesn't drop down right on top of you (which they can!)

Ivan last year kicked off a bunch of smaller tornadoes around here and an F3 that ripped through Marianna. The destruction path on the latter one was unreal; a friend of mine's home took a tree-spear through the roof; the next lot over was wiped completely clean - the house formerly there was cleanly removed from the foundation with the pieces distributed over a wide area.

Please don't take the threat of tornadoes lightly, and if you wake up in the middle of the night hearing something loud and odd......