A new general normal mode approach to dynamic tides in rotating stars with realistic structure and its applications