Unfortunately Android is advanced phone ownership sometimes. You have to grasp at least the concept of what it's doing before you can make an informed choice and some people just don't want to be bothered.
That's why we're here ... to bother you.

I mean to HELP you.
And sometimes it's more a matter of philosophy that technology. Personally I am not a fan of adoptable storage, although I marvel at the implementation.
@Unforgiven explained the "how" of it, let me delve into the "why" (and for me "why not") of it.
Obviously people want more, more, MORE! but we want it fast and we want it cheap and we want it our way. It's called the "American Plan". SD cards are pretty cheap and have been around for a while and are tiny, so where's the problem? First, SD cards are slow, at least in terms of the memory that's soldered to the motherboard of your phone. If you look at the article
@Unforgiven linked it shows you through benchmarks the kind of performance degradation you might see by using an SD card as part of your system even using a class 10 card.
Second, they are fragile. SD cards fail regularly. And they fail without warning. One day they are working just fine and then poof, gone, and without backups you're connected to something using an inclined plane wrapped helically around and axis. Stressing them with the constant read/write cycles of system memory (something which they were never designed for) increases the likelihood of failure.
And it's not always an option.
@Hadron pointed out that some phones don't include an SD card slot. Google, who wrote the darn adoptable feature in the first place, doesn't let you use it with the Pixels (or later Nexuseses) because they don't have SD card slots. LG, who does usually include SD card slots in their phones has chosen to disable adoptable storage for SD cards.
If you ask me, SD cards should be used as they were intended -- external storage. If you run into storage issues because you want to have 250 apps on your phone (I have 357

) and it only has 8GB or 16GB of memory, adoptable storage might look like a solution, but if you ask me you are just setting yourself up for a disappointing and perhaps disastrous experience.