The pipe to nowhere

There is water coming in here too. We took up some floorboards but luckily the joists look okay. This pipe doesn't seem to go anywhere or do anything so I think it'll have to go!

The rain was fortuitous as it shows where the guttering is leaking (multiple)