I found that busses out to UBC are a very, very long (if affordable, and easy tap-to-pay touchless credit credit card) ride. Of course you want to look out the windows. Be careful of sub-routes that don't go all the way. We stayed near the Brentwood area, in my (first time) AirBnb, quite far from town. I suggest you stay downtown. Be careful of sub-routes that don't go all the way.
As a native of Manhattan, I may sound crazy to you, but learning how relatively safe big cities are, especially in Canada, is essential to the two of you begin accepting the idea of college in Vancouver. Anyplace you have a large population, you have more (statistical) crime, because more people live there. That's even before you confront the issue that poor people can live more easily in cities than (where you live???) really rural areas, or wealthy suburbs with exclusionary zoning (like where I live.)
You also have to confront the issue of appearance/Social Media "facts" versus reality. New York City is one of the safest large cities in the USA, but unless you drill down on impartial news sites, that fact is invisible to most of the US, and to the rest of the world. In fact, Vancouver has the worst looking "Skid Row" I've ever seen, and acknowledges its problem with substance abuse and homelessness in that constrained, non-downtown, area. But as Lonely Planet Vancouver told me, you are more likely to be asked for a handout downtown, rather than on that skid row. (I forget the name of the neigborhood. But our bus to downtown went throught it almost every day we set out for an excursion. If this boggles your eyes, you need to think more critically about leaving your home environment.)
The skid row is near Chinatown, but I'd point out that Asian food touches everything today. You certainly don't need to stay in ANY major city's Chinatown to get superb Asian and Asian Fusion food!
My extended family really enjoyed our 2023 reunion in Vancouver, and did not fee "scared" at any time. But as I said, we all grew up in Manhattan (upper West Side), before cell phones, and with bus passes that let us go places between school and dinnertime at home - UNSUPERVISED.