Hello I will be glad to help you with your Honda questions today!
Do you have any Check Engine Lights on? Does the whining noise only seem to occur while turning the wheel?
Ok the good news is there is no lights on which means that there isn't an actual misfire in the engine.
I would start by having the engine mounts checked for the roughness you are describing. If one of the mounts are slightly weak and staring to collapse it can cause the roughness that you are feeling.
The whining noise that you are hearing could be caused by the power steering pump (if you don't have electric steering) or a possible drive belt tensioner. If the bearing is going bad in the tensioner it can cause a slight whine when the steering wheel is turned due to the extra strain on the drive belt.
If the power steering system is low on fluid or the pump is failing it can cause a whine when turning also.
I would have your CR-V checked to see if any of these are causing your problems to prevent any future problems.
Let me know if you have any other questions and I will be glad to help. Please remember to rate me at Excellent Service and Thank You for letting me assist you today!