Less is better. In each industry, there is its own optimal web page size, therefore it is advisable to focus on your competitors. See which websites appear first in the search results. Measure the weight of their websites as well as individual pages.
You should strive to keep the page weight of your website lighter than that of your competitors. Then, there is every chance of overtaking them in the search results, "other things being equal". The average optimal weight per page is approximately 1–1.5 MB, but in general, this value should not exceed 3 MB.
The use of heavy content such as video, photos, and various special effects should be justified. Add large volumes of information only if it is useful to the reader. If you can do without something, feel free to cut such content.