Starlink as a service does work in airplanes, and as
@Brad Z noted above there's an aviation subscription. But note, that's for the 20GB plan. Unlimited is $10k/month, and that's on top of the STC you have to purchase and install you have to do. See their website:
Available now on your airframe.
www.starlink.com
Your standard bug smasher isn't the target market for this (if that wasn't obvious). You're looking at super mid and large cabin bizjets for the most part, the kinds of things where you're already spending $10k/hour to operate the things and are usually being chartered anyway. Those planes virtually all have some sort of internet on them today, and the subscriptions on those aren't cheap, either (although Starlink is currently more, but for a higher quality product).
The antenna is large enough that mounting it on a 172 or the like may be a bit harder (that's a significant part of the STC). However like most technology, it wouldn't surprise me if it eventually trickles down. People already pay a decent chunk for SXM in their planes (more than I was ever willing to pay). If you're willing to pay a subscription price for a SXM weather + audio plan, a $200/month subscription (extrapolating from home and RV plans) wouldn't be out of the question.
But as to today, seems unlikely it would really work. A combination of SXM (for weather and audio - the audio at least you can use with any portable SXM receiver, and I used to do that in my Aztec) and a Garmin InReach probably get you a good chunk of what you're looking for. I have an InReach that I use while riding. Mostly I like it because it's paired with my Zumo XT2 and I can send preset check-in messages to my wife while riding easily. "I'm starting my trip" "I'm checking in, everything is ok" "I'm ending my trip".
When I was flying, I specifically never bought, nor wanted, any kind of 2-way communications. I borrowed a friend's when doing a few international/over water trips for a combination of an added measure of safety, and also because I was doing rescue flights with people who weren't as savvy on FlightAware (which incidentally is less accurate in those areas anyway). It was useful in those cases. However for my standard flying, frankly I didn't want the people who would be trying to contact me to be able to contact me.
It's worth noting that with InReach you have to send or otherwise allow people to contact you on it (I forget the exact mechanisms) so you can't just get random scam text messages. But that's still easier to control nowadays than it was during the Cloud Nine days. People have finally realized I'm not worth talking to.