The quality of your cardio workout is related to the HR you attain and the length of time you keep it there, which you can do on any bike. 99.9% of your cycling is probably aerobic, ergo - good cardio.

Nonetheless, your reasons for getting a road bike are solid.