Rover Way in Cardiff was closed for the funeral cortege to pass through