I live in the US in a suburban area near a major city.
The sports facilities of the local high school would put UCD to shame.
Two pools, one for girls, one for boys.
Two full depth diving wells, one in each pool.
Two full-size basketball courts, eight badminton courts, indoor tennis courts, indoor running track and equipped for all track and field events (pole vaulting, high jump, javelin, etc), climbing walls, volleyball courts - all in field house in two separate areas. Plus two gymnastics gyms and wrestling gyms, and a fully equipped exercise gym with treadmills, weight machines, stationery bikes, rowing machines, etc, where students learn how to use all the equipment and spend a semester having their overall fitness tracked.
Outdoor running track, long jump, baseball field; two hockey/ lacrosse/ soccer fields; American football field plus stadium. Outdoor tennis courts.
Plus all the shower rooms and changing rooms and lockers needed.
The school makes students do PE every day. They rotate through swimming/ diving, gymnastics, dance, team sports (basketball, volleyball), general fitness (gym), racquet sports, health (classroom), driving (in school cars and driving lab), track and field, adventure ed (kayaks in pool, climbing wall, basic first aid) over eight semesters.
Teachers are paid $10k per year extra if they coach an extracurricular sport. There is also a large PE staff.
The local area has use of the high school facilities, and there are numerous sports organisations offering opportunities for kids to get involved in sport - Tball (leading to baseball and softball), pee wee football (leads to flag and American football), swimming lessons and teams. There are opportunities to join travel teams and train amd compete more intensively as kids get older, but this is something parents have to roll up their sleeves for. Local youth sports are run and coached by volunteers.
The local park district runs two outdoor pools in summer, plus one indoor pool and a year-round rink. Ice hockey is huge here. Local parks have superb tennis courts and basketball courts, baseball diamonds, and soccer pitches.
All it takes is money...
And expertise.
The wider area has lots of public facilities too, including several 50m pools.
Not every high school or locality in the state or elsewhere in the US has all of the above, nor have all of the great local facilities resulted in a steady stream of Olympians (though the school has produced a few, both symmer and winter, and the local area always has several), but equipping Irish schools and localities with good and accessible facilities (physically and financially) would make a difference in many lives regardless of whether it turned into a pipeline to the Olympics.
Exercise gyms in all secondary schools would be a good start.