Please, don't confuse your misconception of what dragging the shutter speed would do in your day to day usage vs what professions do with long exposure.
Sure, adding motion blur is an effect one can achieve with long exposure. You need some extra things like ND filters to avoid over exposing, but that a technique someone is specifically looking to achieve. It's not a mistake from something my mom would do.
We've been using long exposure for things like light painting well before Apple/Google. We've been using long exposure for astrophotography for a long time as well. I still feel utter respect for Hubble et al night after night manually guiding the scope to keep the image in frame. In fact, the same frame of film would be exposed for multiple hours each night for multiple nights before finally being developed.
What you've associated things with in your mind does not mean the rest of the world only associates the same things in the same way.