Drilling holes in the floor will not affect the bearing capacity of the floor itself or the house.
After my building was built, the plumber used a special drilling machine to drill holes in the floor, and some people directly knocked out the holes with hoes, and the house was fine.
I suggest you use a special drilling machine to drill holes, which can reduce vibration and improve the quality of holes.
In addition, the hole should be waterproof to avoid water leakage.