Hey Mherr!
I understand your lack of interest- I find myself interested in "dancing" only while on the ground, and my aerial moves (what few of them there are) I just do for exercise and challenge. I do a lot of spins, though.
If I'm honest, I know a lot of moves for pole that I never use. Most of those are… particulalry blatant in the sexy department! I'm not super big on them, and they don't do a lot for my fitness, so I only break them out when I'm feeling silly.
That said, there are a lot of moves that we have in pole that are very difficult, but do include that sexual aspect. The Teddy hold comes to mind- I'm working on that one currently, and I'm finding that the strength and technique is a great challenge, and I don't really focus on the fact that the move is very much based on "LOOK! Look between my legs!" I know that, once I get better at the hold, I can adjust it to fit my own needs a bit more, and make it less… showy.
For spins, I find that they really helped me increase my strength, and helped me learn to trust my pole a lot more than any invert or aerial move I know. They really work a lot of your upper body and core muscles. As you progress, they get harder and harder- I'm still trying to get my reverse grab spin going properly! Spins can also help with the "dancing" aspect of pole, but I'm guessing you're not totally into that.
Someone to look up would be Poledancefan, as he went into this with the intention of fitness as well. I really think he did some amazing things, got out of his comfort zone, and eventually, he achieved his dream move, and beyond! I'm pretty sure he's got some videos on youtube and possibly here.
Honestly, you don't NEED to work on spins, transitions, floorwork or any of that! You can work on the stuff you like. But, I would be careful getting into any kinds of inversions right now, because you could do a lot of damage! I think that, if you only want to do aerial work, you'll need to do a lot more other kinds of exercise, too. Like, weight lifting and other strength work, in order to get your muscfles ready.