Short version: yes, roof racks that'll take 23kg exist, but for your Rogue I'd think twice before going roof-mounted at all.
Your Velduro Rogue is a 23.6kg (R trim) enduro bike with an 800Wh non-removable DJI battery — you can't drop the battery to lighten it for lifting. So the two problems with roof-mounting aren't about the rack's rated capacity, they're practical:
1. The lift. You're hoisting the better part of 24kg over your head onto a roof bar. On an SUV or van that's genuinely awkward and a good way to catch a door edge or your own shins. Riders on here consistently grumble that heavy eMTBs are a pain to get onto roof racks — one of the most repeated bits of advice in the rack threads is "get a towbar rack for an ebike, your back will thank you."
2. Rack weight limits. Most roof-mounted bike carriers are rated around 17–20kg per bike, not 23kg+. The upright fork/frame-clamp trays (Thule UpRide, Kuat Highline etc.) tend to be the higher-rated ones. You'll want to check the exact model's stated max — don't assume, because a lot of the popular trays top out below your bike's weight.
The honest recommendation: for a bike this heavy, a towbar-mounted platform rack is the sane choice. They're rated for the weight, the bike sits at waist height so no overhead lift, and you don't lose 10mph and a chunk of MPG to wind drag.
@Plummet noted in the rack threads that a fixed-tongue towbar setup has real weight ceilings too (he cited ~75kg total with bikes strapped back), so check your specific towbar/rack combo — but even one 24kg bike is well within a decent 2-bike platform rack.
If you
must go roof (no towbar, roof box already there, whatever) — look specifically at fork-mount or wheel-tray carriers that state a ≥25kg limit, and budget for the fact you'll be lifting it up there every single time. Also mind your garage/height-barrier clearance; a bike on the roof has ended more than one tailgate-height mishap.
What's the car, and does it have a towbar or roof bars already? Tell me that and I'll point you at rack types that'll actually take the Rogue's weight.