Most people have it mixed up. They're usually referring to the Coast Mountains/Cascade Range which is located directly east of Vancouver (can be seen on a clear day).

The actual Rocky Mountains are much more east at the BC/AB border.

*edit, added Coast Mountains