There is a little bit of stigma, like aces being "prudes," but yeah it's nothing super jarring with loads of popular slurs for it.

And yeah it would pretty much only come up when people talk about sex in ways that assume everyone enjoys it or automatically wants it from their romantic partner. Basically just challenging relationship norms hammered in since those wild high school days...

It's cool aces are getting more representation in mainstream media though. Not many ace characters out there for people to name off the top of their head. Todd from Bojack Horseman is the only one that comes to mind for me.