The singer has become a social media sensation, and now she's showing off and begging for an orgasm in her first adult video