Yes, multiple scenes are common practise. Using it to stitch game worlds is not common though. Most terrain systems would have their own, more optimal/efficient ways of doing that.

https://docs.unity3d.com/ScriptReference/SceneManagement.Loa...

https://gamedevacademy.org/a-guide-to-handling-huge-worlds-i...