Google’s initial tablet, the Google Nexus lineup was not meet with much success. The Google Nexus 7 with a 7 inch form factor did well but it was more of a surprise hit. After the disastrous start with Android tablets Google launched the Pixel Slate running Chrome OS in 2018.
However, even the Google Pixel Slate offered a not well received user experience, performance and failed to attract consumers.
This does not mean that Android or Chrome OS tablets themselves are dead. While you will have a hard time finding Android tablets in the market, Google will continue to support OEMs who are interested in launching such tablets. Samsung is currently the only major OEM which continues to launch Android tablets.