would a prince of space, someone who destroys space, have powers akin to Roxys? Like they could destroy the space and make something in its place?

Nope, they’d have to be a Prince of Void, and even then the Prince’s powers are more direct and blunt than the Rogue’s, so it’s likely even then they wouldn’t be able to quite match what a Rogue could do.