Yeah, it is definitely not for us, but then, even the 50 MP 5Ds R is not for us. Corner to corner sharpness will not apply here as the image will be cropped to get the macro effect. Details that can be grabbed will depend on the lighting and there will be a lot more flexibility to light with a regular lens. This is just speculation though. Canon themselves are not discussing use case right now. They are only doing technical demonstrations of what the camera can do, not where it will be used.
Canon have introduced a macro lens with in-built flash units for lighting the subject, so there is emphasis on lighting for macro, but there is no reason to believe, at this stage, that macro will be a thrust application for the new camera.
I don't think such a camera will be useful for BIFs. Even a 36 MP camera may struggle, based on all the complaints I've heard. The future for wildlife photography seems to be heading towards stills from 4K video.
I think Lytro have moved on to making lightfield cameras for VR. I also remember reading something about them exploring the defence market as the consumer market failed to takeoff. I may be wrong, though.