BlogPro and Notion support a variety of video sources. BlogPro will cache Notion assets in its own storage to make serving assets as fast and as reliably as possible.

You can embed videos from youtube, simply by pasting the youtube url on Notion and clicking "Embed video"

You can also embed a video dropping a local file on Notion.

BlogPro supports GIFs as well (keep in mind GIFs are more heavy than videos and videos are always preferred.