From Android Police

I turned off my Pixel's Motion Photo for a week and weighed the storage gain against missed shots

It's not worth the space

Read the full report at Android Police ↗