Spacing out is basically all it does. It turns back into Slowpoke if its tail, along with Shellder, breaks off.
SLOWBRO’s tail has a SHELLDER firmly attached with a bite. As a result, the tail can’t be used for fishing anymore. This causes SLOWBRO to grudgingly swim and catch prey instead.