It was new technology, 3D was a fairly new concept in gaming in the mid 90s. But it took so long to get properly implemented. You have super mario 64, gex enter the gecko, lemmings 3D. I am wondering if it was a business decision and not the devs who pushed for a free roaming camera, since it was clearly not a satisfactory result gameplay wise. Because at the same era, you have games with fixed camera angles that are much better experiences overall.
Video game cameras peaked here:
I can't recall another game with a free roam camera that gave lore to their camera. You control two characters at the same time!
My head canon is that Lakitu is the camera operator in all Nintendo games to this day.