The short answer is that you can use either prosecco or champagne with a pornstar martini. It is most commonly served with prosecco given that it is less costly and widely available. However, you can use champagne if you want to make the drink even more decadent.
You could alternatively use any other variety of sparkling wine you have available such as Cava. Personally, I actually prefer prosecco, given its drier taste.